<?php

class Pengaduan_saran extends arfaController{
	
	public function __construct()
	{
		parent::__construct();
		$this->load->model("m_ps_pemohon");
		$this->load->model("m_list_pengaduan");
		$this->load->model("m_list_saran");
		$this->load->model("m_ijin_model");
		$this->load->model("m_proses_pengaduan_saran");
	}
	
	public function grid_dari_pemohon()
	{
		$data["data_ps_pemohon"] = $this->m_ps_pemohon->get_data();
		$data["menu"] 		= "admin";
		$data["content"] 	= $this->load->view("v_grid_ps_pemohon",$data,true);
		$this->load->view("main",$data);
	}
	
	public function grid_list_pengaduan()
	{
		$data["data_list_pengaduan"] = $this->m_list_pengaduan->get_data();
		$data["menu"] 		= "admin";
		$data["content"] 	= $this->load->view("v_grid_list_pengaduan",$data,true);
		$this->load->view("main",$data);
	}
	
	public function grid_list_saran()
	{
		$data["data_list_saran"] = $this->m_list_saran->get_data();
		$data["menu"] 		= "admin";
		$data["content"] 	= $this->load->view("v_grid_list_saran",$data,true);
		$this->load->view("main",$data);
	}
	
	public function form_input_ps($id = NULL , $id_saran = NULL)
	{
		$this->form_validation->set_rules("nama","Nama","required");
		$this->form_validation->set_rules("no_telp","Nomor Telepon","required");
		$this->form_validation->set_rules("email","Email","required");
		$this->form_validation->set_rules("isi","Isi","required");
	
		if($this->form_validation->run() == FALSE)
		{
			if(!isset($id))
			{
				$data["media"] = array(
				"" => "-- Pilih Media --",
				1 => "Langsung",
				2 => "Telepon",
				3 => "Email",
				4 => "Website"
				);
				$data["menu"] 			= "admin";
				$data["dropdown_ijin"] 	= $this->m_ijin_model->get();
				$data["post_action"]	= "pengaduan_saran/form_input_ps/";
				$data["content"] 		= $this->load->view("form_input_ps",$data,true);
				$this->load->view("main",$data);
			}
			else
			{
				if(!isset($id_saran)){
					$data["id"]	= $id;
					$data["media"] = array(
					"" => "-- Pilih Media --",
					1 => "Langsung",
					2 => "Telepon",
					3 => "Email",
					4 => "Website"
					);
					$data["menu"]					= "admin";
					$data["dropdown_ijin"] 			= $this->m_ijin_model->get();
					$data["list"]					= $this->m_list_pengaduan->get($id);
					$data["post_action"]			= "pengaduan_saran/form_input_ps/".$id;
					$data["content"]				= $this->load->view("form_input_ps",$data,true);
					$this->load->view("main",$data);
				}
				else
				{
					echo "saran";
					$data["id"]	= $id;
					$data["id_saran"] = $id_saran;
					$data["media"] = array(
					"" => "-- Pilih Media --",
					1 => "Langsung",
					2 => "Telepon",
					3 => "Email",
					4 => "Website"
					);
					$data["menu"]					= "admin";
					$data["dropdown_ijin"] 			= $this->m_ijin_model->get();
					$data["list"]					= $this->m_list_saran->get($id);
					$data["post_action"]			= "pengaduan_saran/form_input_ps/".$id;
					$data["content"]				= $this->load->view("form_input_ps",$data,true);
					$this->load->view("main",$data);
				}
			}
		}
		else
		{
			$get_nama 			= $this->input->post("nama");
			$get_notelp			= $this->input->post("no_telp");
			$get_email			= $this->input->post("email");
			$get_isi			= $this->input->post("isi");
			$get_media			= $this->input->post("media");
			$get_masukan		= $this->input->post("jenis_masukan");
			$get_ijin			= $this->input->post("ijin");
			$get_uptsa			= $this->input->post("no_uptsa");
			$get_tanggal		= $this->input->post("tanggal");
			$get_terkait_ijin	= $this->input->post("terkait_ijin");
			
			if($get_masukan == 1)
			{
				if($get_terkait_ijin == 1)
				{
					$data = array(
						"NAMA" 			=> $get_nama,
						"NO_TELEPON" 	=> $get_notelp,
						"EMAIL"			=> $get_email,
						"ISI"			=> $get_isi,
						"MEDIA"			=> $get_media,
						"KD_IJIN"		=> $get_ijin,
						"NO_UPTSA"		=> $get_uptsa,
						"TANGGAL"		=> date('Y-m-d', strtotime($get_tanggal)),
						"STATUS"		=> 2
					);
					
					if(!isset($id))
					{
						$this->m_list_pengaduan->save($data);
						echo "<script>alert('Data berhasil disimpan !');</script>";
						echo "<script>document.location='';</script>";
					}
					else
					{
						$this->m_list_pengaduan->save($data,$id);
						redirect("pengaduan_saran/grid_list_pengaduan");
					}
				}
				elseif($get_terkait_ijin == 2)
				{
					$data = array(
						"NAMA" 			=> $get_nama,
						"NO_TELEPON" 	=> $get_notelp,
						"EMAIL"			=> $get_email,
						"ISI"			=> $get_isi,
						"MEDIA"			=> $get_media,
						"KD_IJIN"		=> NULL,
						"NO_UPTSA"		=> NULL,
						"TANGGAL"		=> date('Y-m-d', strtotime($get_tanggal)),
						"STATUS"		=> 2
					);
					
					if(!isset($id))
					{
						$this->m_list_pengaduan->save($data);
						echo "<script>alert('Data berhasil disimpan !');</script>";
						echo "<script>document.location='';</script>";
					}
					else
					{
						$this->m_list_pengaduan->save($data,$id);
						redirect("pengaduan_saran/grid_list_pengaduan");
					}
				}
				
			}
			elseif($get_masukan == 2)
			{
				if($get_terkait_ijin == 1)
				{
					$data = array(
						"NAMA" 			=> $get_nama,
						"NO_TELEPON" 	=> $get_notelp,
						"EMAIL"			=> $get_email,
						"ISI"			=> $get_isi,
						"MEDIA"			=> $get_media,
						"KD_IJIN"		=> $get_ijin,
						"NO_UPTSA"		=> $get_uptsa,
						"TANGGAL"		=> date('Y-m-d', strtotime($get_tanggal)),
					);
					
					if(!isset($id))
					{
						$this->m_list_saran->save($data);
						echo "<script>alert('Data berhasil disimpan !');</script>";
						echo "<script>document.location='';</script>";
					}
					else
					{
						$this->m_list_saran->save($data,$id);
						redirect("pengaduan_saran/grid_list_saran");
					}
				}
				elseif($get_terkait_ijin == 2)
				{
					$data = array(
						"NAMA" 			=> $get_nama,
						"NO_TELEPON" 	=> $get_notelp,
						"EMAIL"			=> $get_email,
						"ISI"			=> $get_isi,
						"MEDIA"			=> $get_media,
						"KD_IJIN"		=> NULL,
						"NO_UPTSA"		=> NULL,
						"TANGGAL"		=> date('Y-m-d', strtotime($get_tanggal)),
					);
					
					if(!isset($id))
					{
						$this->m_list_saran->save($data);
						echo "<script>alert('Data berhasil disimpan !');</script>";
						echo "<script>document.location='';</script>";
					}
					else
					{
						$this->m_list_saran->save($data,$id);
						redirect("pengaduan_saran/grid_list_saran");
					}
				}
			}
		}
		
	}
	
	public function form_tindak_lanjut($id = NULL)
	{
		$this->form_validation->set_rules("form_input","Form Proses","required");
		
		if($this->form_validation->run() == FALSE)
		{
			$data["id"] = $id;
			$data["menu"]	= "admin";
			$data["get_id_status"] = $this->m_list_pengaduan->select_data($id);
			$data["get_data_proses"] = $this->m_proses_pengaduan_saran->get_all($id);
			$data["post_action"] = "pengaduan_saran/form_tindak_lanjut/".$id;
			$data["post_action2"] = "pengaduan_saran/cek_status";
			$data["post_action3"] = "pengaduan_saran/pengaduan_ulang";
			$data["content"] = $this->load->view("form_tindak_lanjut_pengaduan",$data,true);
			$this->load->view("main",$data);
		}
		else
		{
			$get_id_pengaduan = $id;
			$get_datetime = date("Y-m-d H:i:s");
			$get_keterangan = $this->input->post("form_input");
			
			$data = array(
				"KD_PENGADUAN_SARAN" => $get_id_pengaduan,
				"TANGGAL" => $get_datetime,
				"KETERANGAN" => $get_keterangan,
				"TESTIMONI" => 0
			);
			
			$this->m_proses_pengaduan_saran->save($data);
			echo "<script>alert('Data berhasil disimpan !');</script>";
			echo "<script>document.location='';</script>";
		}
	}
	
	public function cek_status()
	{
		$this->form_validation->set_rules("testimoni","Proses","required");
	
		$get_id = $this->input->post("id_testimoni");
		$get_datetime = date("Y-m-d H:i:i");
		$get_testimoni = $this->input->post("testimoni");
		
		$data = array(
			"KD_PENGADUAN_SARAN" => $get_id,
			"TANGGAL" => $get_datetime,
			"KETERANGAN" => $get_testimoni,
			"TESTIMONI" => 1
		);
		$this->m_proses_pengaduan_saran->save($data);
		$data = array(
			"STATUS" => 1
		);
		$this->m_list_pengaduan->save($data,$get_id);
		redirect("pengaduan_saran/form_tindak_lanjut/".$get_id);
	}
	
	public function pengaduan_ulang()
	{
		$this->form_validation->set_rules("pesan","Proses","required");
	
		$get_id = $this->input->post("id_ulang");
		$get_datetime = date("Y-m-d H:i:i");
		$get_pesan = $this->input->post("pesan");
		
		$data = array(
			"KD_PENGADUAN_SARAN" => $get_id,
			"TANGGAL" => $get_datetime,
			"KETERANGAN" => $get_pesan,
			"TESTIMONI" => 2
		);
		$this->m_proses_pengaduan_saran->save($data);
		redirect("pengaduan_saran/form_tindak_lanjut/".$get_id);
	}
	
	public function savetopengaduan()
	{
		$id	= $this->input->post("id");
		$row = $this->m_ps_pemohon->get($id);
		$data = array(
			"NAMA"			=> $row['NAMA'],
			"NO_TELEPON"	=> $row['NO_TELPON'],
			"EMAIL"			=> $row['EMAIL'],
			"ISI"			=> $row['ISI'],
			"MEDIA"			=> $row['MEDIA'],
			"KD_IJIN"		=> $row['KD_IJIN'],
			"NO_UPTSA"		=> $row['NO_UPTSA'],
			"TANGGAL"		=> $row['TANGGAL'],
			"STATUS"		=> 2,
			"KATEGORI_P"	=> $this->input->post("j_pengaduan")
		);
		$this->m_list_pengaduan->save($data);
		$this->m_ps_pemohon->delete($id);
		redirect("pengaduan_saran/grid_dari_pemohon");
	}
	
	public function savetosaran()
	{
		$id	= $this->input->post("id");
		$row = $this->m_ps_pemohon->get($id);
		$data = array(
			"NAMA"			=> $row['NAMA'],
			"NO_TELEPON"	=> $row['NO_TELPON'],
			"EMAIL"			=> $row['EMAIL'],
			"ISI"			=> $row['ISI'],
			"MEDIA"			=> $row['MEDIA'],
			"KD_IJIN"		=> $row['KD_IJIN'],
			"NO_UPTSA"		=> $row['NO_UPTSA'],
			"TANGGAL"		=> $row['TANGGAL'],
			"KATEGORI_S"	=> $this->input->post("j_saran")
		);
		$this->m_list_saran->save($data);
		$this->m_ps_pemohon->delete($id);
		redirect("pengaduan_saran/grid_dari_pemohon");
	}
	
	public function data_report()
	{
		$this->load->library('PHPExcel');
		$this->load->library('PHPExcel/IOFactory');
	
		$this->form_validation->set_rules("tanggal_awal","Tangga Awal","required");
		$this->form_validation->set_rules("tanggal_akhir","Tangga Akhir","required");
		$this->form_validation->set_rules("jenis_cetak","Jenis Cetak","required");
		
		if($this->form_validation->run() == FALSE)
		{
			$data["menu"]			= "admin";
			$data["post_action"]	= "pengaduan_saran/data_report";
			$data["content"]		= $this->load->view("form_data_report_saran",$data,true);
			$this->load->view("main",$data);
		}
		else
		{
			$get_taw		= date('Y-m-d', strtotime($this->input->post("tanggal_awal")));
			$get_tak		= date('Y-m-d', strtotime($this->input->post("tanggal_akhir")));
			$get_data		= $this->m_list_saran->get_tanggal($get_taw,$get_tak);
			$get_ikm		= $this->m_list_saran->get_tanggal_ikm($get_taw,$get_tak);
			$get_dapen		= $this->m_list_pengaduan->get_tanggal($get_taw,$get_tak);
			$get_dapen_skrk = $this->m_list_pengaduan->get_skrk($get_taw,$get_tak);
			$get_dapen_imb 	= $this->m_list_pengaduan->get_imb($get_taw,$get_tak);
			$get_dapen_ho 	= $this->m_list_pengaduan->get_ho($get_taw,$get_tak);
			$get_dapen_tdup	= $this->m_list_pengaduan->get_tdup($get_taw,$get_tak);
			$get_dapen_ssw	= $this->m_list_pengaduan->get_ssw($get_taw,$get_tak);
			$get_dapen_siup	= $this->m_list_pengaduan->get_siup($get_taw,$get_tak);
			$get_dapen_ipt	= $this->m_list_pengaduan->get_ipt($get_taw,$get_tak);
			$get_dapen_lain	= $this->m_list_pengaduan->get_lain($get_taw,$get_tak);
			
			$date = date('m');
			if($date == 1){
				$get_date = "Januari";
			}elseif($date == 2){
				$get_date = "Februari";
			}elseif($date == 3){
				$get_date = "Maret";
			}elseif($date == 4){
				$get_date = "April";
			}elseif($date == 5){
				$get_date = "Mei";
			}elseif($date == 6){
				$get_date = "Juni";
			}elseif($date == 7){
				$get_date = "Juli";
			}elseif($date == 8){
				$get_date = "Agustus";
			}elseif($date == 9){
				$get_date = "September";
			}elseif($date == 10){
				$get_date = "Oktober";
			}elseif($date == 11){
				$get_date = "November";
			}elseif($date == 12){
				$get_date = "Desember";
			}
			
			if($this->input->post("jenis_cetak") == 1)
			{
				// Semua IJIN
			
				$objPHPExcel = new PHPExcel();
				$objPHPExcel->getSheet(0)->setTitle('Semua Ijin');
				$objPHPExcel->getProperties()->setTitle("title")->setDescription("description");
				
				$objPHPExcel->setActiveSheetIndex(0);
				
				$objPHPExcel->setActiveSheetIndex(0)->mergeCells('A1:J1');
				$objPHPExcel->setActiveSheetIndex(0)->mergeCells('A2:J2');
				$objPHPExcel->setActiveSheetIndex(0)->mergeCells('B4:C4');
				
				$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setAutoSize(true);
				$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setAutoSize(true);
				$objPHPExcel->getActiveSheet()->getColumnDimension('C')->setAutoSize(true);
				$objPHPExcel->getActiveSheet()->getColumnDimension('D')->setAutoSize(true);
				$objPHPExcel->getActiveSheet()->getColumnDimension('E')->setAutoSize(true);
				$objPHPExcel->getActiveSheet()->getColumnDimension('F')->setAutoSize(true);
				$objPHPExcel->getActiveSheet()->getColumnDimension('G')->setAutoSize(true);
				$objPHPExcel->getActiveSheet()->getColumnDimension('H')->setAutoSize(false);
				$objPHPExcel->getActiveSheet()->getColumnDimension('H')->setWidth(50);
				$objPHPExcel->getActiveSheet()->getColumnDimension('I')->setAutoSize(true);
				$objPHPExcel->getActiveSheet()->getColumnDimension('J')->setAutoSize(true);
				
				$objPHPExcel->getDefaultStyle()->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
				$objPHPExcel->getDefaultStyle()->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
				
				$objPHPExcel->setActiveSheetIndex(0)->getStyle('A6:J6')->applyFromArray(
					array(
						'fill' => array(
							'type' => PHPExcel_Style_Fill::FILL_SOLID,
							'color' => array('rgb' => 'FFFF00')
						)
					)
				);
				
				
				$objPHPExcel->getActiveSheet()->getStyle('A4')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet()->getStyle('A4')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet()->getStyle('A4')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet()->getStyle('A4')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				
				$objPHPExcel->getActiveSheet()->getStyle('A6')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet()->getStyle('A6')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet()->getStyle('A6')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet()->getStyle('A6')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet()->getStyle('B6')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet()->getStyle('B6')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet()->getStyle('B6')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet()->getStyle('B6')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet()->getStyle('C6')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet()->getStyle('C6')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet()->getStyle('C6')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet()->getStyle('C6')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet()->getStyle('D6')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet()->getStyle('D6')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet()->getStyle('D6')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet()->getStyle('D6')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet()->getStyle('E6')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet()->getStyle('E6')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet()->getStyle('E6')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet()->getStyle('E6')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet()->getStyle('F6')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet()->getStyle('F6')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet()->getStyle('F6')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet()->getStyle('F6')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet()->getStyle('G6')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet()->getStyle('G6')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet()->getStyle('G6')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet()->getStyle('G6')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet()->getStyle('H6')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet()->getStyle('H6')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet()->getStyle('H6')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet()->getStyle('H6')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet()->getStyle('I6')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet()->getStyle('I6')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet()->getStyle('I6')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet()->getStyle('I6')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet()->getStyle('J6')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet()->getStyle('J6')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet()->getStyle('J6')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet()->getStyle('J6')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				
				$objPHPExcel->getActiveSheet()->getStyle('A1')->getFont()->setSize(22);
				$objPHPExcel->getActiveSheet()->getStyle('A2')->getFont()->setSize(12);
				$objPHPExcel->getActiveSheet()->getStyle('B4')->getFont()->setSize(12);
				$objPHPExcel->getActiveSheet()->getStyle('A1')->getFont()->setBold(true);
				$objPHPExcel->getActiveSheet()->getStyle('A6:J6')->getFont()->setBold(true);
				
				$objPHPExcel->getActiveSheet()->setCellValue('A1', "LAPORAN PENANGANAN KOMPLAIN");
				$objPHPExcel->getActiveSheet()->setCellValue('A2', "Tanggal Pelaporan : ".date('d-m-Y',strtotime($get_taw))." - ".date('d-m-Y',strtotime($get_tak)));
				$objPHPExcel->getActiveSheet()->setCellValue('B4', "Bulan : ".$get_date." ".date('Y'));
				
				$objPHPExcel->getActiveSheet()->setCellValue('A6', "No");
				$objPHPExcel->getActiveSheet()->setCellValue('B6', "Tanggal");
				$objPHPExcel->getActiveSheet()->setCellValue('C6', "Nama Pemohon / Pelapor");
				$objPHPExcel->getActiveSheet()->setCellValue('D6', "No. Telepon");
				$objPHPExcel->getActiveSheet()->setCellValue('E6', "Email");
				$objPHPExcel->getActiveSheet()->setCellValue('F6', "No. UPTSA");
				$objPHPExcel->getActiveSheet()->setCellValue('G6', "Ijin yang diajukan");
				$objPHPExcel->getActiveSheet()->setCellValue('H6', "Isi Komplain");
				$objPHPExcel->getActiveSheet()->setCellValue('I6', "Keterangan");
				$objPHPExcel->getActiveSheet()->setCellValue('J6', "Verifikasi");
				
				
				$no 		= 1;
				$numb 		= 7;
				$status		= "";
				foreach($get_dapen as $row)
				{
					$get_proses 	= $this->m_proses_pengaduan_saran->get_proses($row["KD_LIST_PENGADUAN"]);
					$get_verifikasi	= $this->m_proses_pengaduan_saran->get_verifikasi($row["KD_LIST_PENGADUAN"]);
					if($row["STATUS"] == 1)
					{
						$status = "SELESAI";
					}
					elseif($row["STATUS"] == 2)
					{
						$status = "PROSES";
					}
				
					$objPHPExcel->getActiveSheet()->getStyle('A'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('A'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('A'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('A'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('B'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('B'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('B'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('B'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('C'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('C'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('C'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('C'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('D'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('D'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('D'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('D'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('E'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('E'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('E'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('E'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('F'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('F'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('F'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('F'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('G'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('G'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('G'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('G'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('H'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('H'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('H'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('H'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('I'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('I'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('I'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('I'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('J'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('J'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('J'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('J'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					
					$objPHPExcel->getActiveSheet()->setCellValue('A'.$numb, $no);
					$objPHPExcel->getActiveSheet()->setCellValue('B'.$numb, date('d-m-Y',strtotime($row["TANGGAL"])));
					$objPHPExcel->getActiveSheet()->setCellValue('C'.$numb, $row["NAMA"]);
					$objPHPExcel->getActiveSheet()->setCellValue('D'.$numb, $row["NO_TELEPON"]);
					$objPHPExcel->getActiveSheet()->setCellValue('E'.$numb, $row["EMAIL"]);
					$objPHPExcel->getActiveSheet()->setCellValue('F'.$numb, $row["NO_UPTSA"]);
					$objPHPExcel->getActiveSheet()->setCellValue('G'.$numb, $row["NAMA_IJIN"]);
					$objPHPExcel->getActiveSheet()->setCellValue('H'.$numb, $row["ISI"]);
					$objPHPExcel->getActiveSheet()->getStyle('H'.$numb)->getAlignment()->setWrapText(true);
					$string = "";
					$i = 0;
					foreach($get_proses as $row){
						$get_dates = "";
						if(date('m',strtotime($row["TANGGAL"])) == 1){
							$get_dates = "Januari";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 2){
							$get_date = "Februari";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 3){
							$get_dates = "Maret";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 4){
							$get_dates = "April";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 5){
							$get_dates = "Mei";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 6){
							$get_dates = "Juni";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 7){
							$get_dates = "Juli";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 8){
							$get_dates = "Agustus";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 9){
							$get_dates = "September";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 10){
							$get_dates = "Oktober";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 11){
							$get_dates = "November";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 12){
							$get_dates = "Desember";
						}
						$string .= " > ".date('d',strtotime($row["TANGGAL"]))." ".$get_dates." ".date('Y',strtotime($row["TANGGAL"])).", ".$row["KETERANGAN"]."\n";
						$i++;
					};
					$objPHPExcel->getActiveSheet()->setCellValue('I'.$numb, $string);
					$objPHPExcel->getActiveSheet()->getStyle('I'.$numb)->getAlignment()->setWrapText(true);
					$objPHPExcel->getActiveSheet()->getStyle('I'.$numb)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
					$string2 = "";
					$j = 0;
					foreach($get_verifikasi as $row){
						$get_dates = "";
						if(date('m',strtotime($row["TANGGAL"])) == 1){
							$get_dates = "Januari";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 2){
							$get_date = "Februari";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 3){
							$get_dates = "Maret";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 4){
							$get_dates = "April";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 5){
							$get_dates = "Mei";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 6){
							$get_dates = "Juni";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 7){
							$get_dates = "Juli";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 8){
							$get_dates = "Agustus";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 9){
							$get_dates = "September";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 10){
							$get_dates = "Oktober";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 11){
							$get_dates = "November";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 12){
							$get_dates = "Desember";
						}
						$string2 .= $row["KETERANGAN"]."\n"."Tgl, ".date('d',strtotime($row["TANGGAL"]))." ".$get_dates." ".date('Y',strtotime($row["TANGGAL"]));
						$i++;
					};
					$objPHPExcel->getActiveSheet()->setCellValue('J'.$numb, $status."\n".$string2);
					$objPHPExcel->getActiveSheet()->getStyle('J'.$numb)->getAlignment()->setWrapText(true);
					$numb++;
					$no++;
				}
				
				//ijin SKRK
				$objPHPExcel->createSheet(1);
				$objPHPExcel->getSheet(1)->setTitle('SKRK');
				
				$objPHPExcel->setActiveSheetIndex(1);
				
				$objPHPExcel->setActiveSheetIndex(1)->mergeCells('A1:J1');
				$objPHPExcel->setActiveSheetIndex(1)->mergeCells('A2:J2');
				$objPHPExcel->setActiveSheetIndex(1)->mergeCells('B4:C4');
				
				$objPHPExcel->getActiveSheet(1)->getColumnDimension('A')->setAutoSize(true);
				$objPHPExcel->getActiveSheet(1)->getColumnDimension('B')->setAutoSize(true);
				$objPHPExcel->getActiveSheet(1)->getColumnDimension('C')->setAutoSize(true);
				$objPHPExcel->getActiveSheet(1)->getColumnDimension('D')->setAutoSize(true);
				$objPHPExcel->getActiveSheet(1)->getColumnDimension('E')->setAutoSize(true);
				$objPHPExcel->getActiveSheet(1)->getColumnDimension('F')->setAutoSize(true);
				$objPHPExcel->getActiveSheet(1)->getColumnDimension('G')->setAutoSize(true);
				$objPHPExcel->getActiveSheet(1)->getColumnDimension('H')->setAutoSize(false);
				$objPHPExcel->getActiveSheet(1)->getColumnDimension('H')->setWidth(50);
				$objPHPExcel->getActiveSheet(1)->getColumnDimension('I')->setAutoSize(true);
				$objPHPExcel->getActiveSheet(1)->getColumnDimension('J')->setAutoSize(true);
				
				$objPHPExcel->getDefaultStyle()->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
				
				$objPHPExcel->setActiveSheetIndex(1)->getStyle('A6:J6')->applyFromArray(
					array(
						'fill' => array(
							'type' => PHPExcel_Style_Fill::FILL_SOLID,
							'color' => array('rgb' => 'FFFF00')
						)
					)
				);
				
				
				$objPHPExcel->getActiveSheet(1)->getStyle('A4')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(1)->getStyle('A4')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(1)->getStyle('A4')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(1)->getStyle('A4')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				
				$objPHPExcel->getActiveSheet(1)->getStyle('A6')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(1)->getStyle('A6')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(1)->getStyle('A6')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(1)->getStyle('A6')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(1)->getStyle('B6')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(1)->getStyle('B6')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(1)->getStyle('B6')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(1)->getStyle('B6')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(1)->getStyle('C6')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(1)->getStyle('C6')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(1)->getStyle('C6')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(1)->getStyle('C6')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(1)->getStyle('D6')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(1)->getStyle('D6')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(1)->getStyle('D6')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(1)->getStyle('D6')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(1)->getStyle('E6')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(1)->getStyle('E6')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(1)->getStyle('E6')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(1)->getStyle('E6')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(1)->getStyle('F6')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(1)->getStyle('F6')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(1)->getStyle('F6')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(1)->getStyle('F6')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(1)->getStyle('G6')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(1)->getStyle('G6')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(1)->getStyle('G6')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(1)->getStyle('G6')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(1)->getStyle('H6')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(1)->getStyle('H6')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(1)->getStyle('H6')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(1)->getStyle('H6')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(1)->getStyle('I6')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(1)->getStyle('I6')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(1)->getStyle('I6')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(1)->getStyle('I6')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(1)->getStyle('J6')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(1)->getStyle('J6')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(1)->getStyle('J6')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(1)->getStyle('J6')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				
				$objPHPExcel->getActiveSheet(1)->getStyle('A1')->getFont()->setSize(22);
				$objPHPExcel->getActiveSheet(1)->getStyle('A2')->getFont()->setSize(12);
				$objPHPExcel->getActiveSheet(1)->getStyle('B4')->getFont()->setSize(12);
				$objPHPExcel->getActiveSheet(1)->getStyle('A1')->getFont()->setBold(true);
				$objPHPExcel->getActiveSheet(1)->getStyle('A6:J6')->getFont()->setBold(true);
				
				$objPHPExcel->getActiveSheet(1)->setCellValue('A1', "LAPORAN PENANGANAN KOMPLAIN");
				$objPHPExcel->getActiveSheet(1)->setCellValue('A2', "Tanggal Pelaporan : ".date('d-m-Y',strtotime($get_taw))." - ".date('d-m-Y',strtotime($get_tak)));
				$objPHPExcel->getActiveSheet(1)->setCellValue('B4', "Bulan : ".$get_date." ".date('Y'));
				
				$objPHPExcel->getActiveSheet(1)->setCellValue('A6', "No");
				$objPHPExcel->getActiveSheet(1)->setCellValue('B6', "Tanggal");
				$objPHPExcel->getActiveSheet(1)->setCellValue('C6', "Nama Pemohon / Pelapor");
				$objPHPExcel->getActiveSheet(1)->setCellValue('D6', "No. Telepon");
				$objPHPExcel->getActiveSheet(1)->setCellValue('E6', "Email");
				$objPHPExcel->getActiveSheet(1)->setCellValue('F6', "No. UPTSA");
				$objPHPExcel->getActiveSheet(1)->setCellValue('G6', "Ijin yang diajukan");
				$objPHPExcel->getActiveSheet(1)->setCellValue('H6', "Isi Komplain");
				$objPHPExcel->getActiveSheet(1)->setCellValue('I6', "Keterangan");
				$objPHPExcel->getActiveSheet(1)->setCellValue('J6', "Verifikasi");
				
				$no 		= 1;
				$numb 		= 7;
				$status		= "";
				foreach($get_dapen_skrk as $row)
				{
					$get_proses 	= $this->m_proses_pengaduan_saran->get_proses($row["KD_LIST_PENGADUAN"]);
					$get_verifikasi	= $this->m_proses_pengaduan_saran->get_verifikasi($row["KD_LIST_PENGADUAN"]);
					if($row["STATUS"] == 1)
					{
						$status = "SELESAI";
					}
					elseif($row["STATUS"] == 2)
					{
						$status = "PROSES";
					}
				
					$objPHPExcel->getActiveSheet(1)->getStyle('A'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(1)->getStyle('A'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(1)->getStyle('A'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(1)->getStyle('A'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(1)->getStyle('B'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(1)->getStyle('B'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(1)->getStyle('B'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(1)->getStyle('B'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(1)->getStyle('C'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(1)->getStyle('C'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(1)->getStyle('C'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(1)->getStyle('C'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(1)->getStyle('D'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(1)->getStyle('D'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(1)->getStyle('D'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(1)->getStyle('D'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(1)->getStyle('E'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(1)->getStyle('E'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(1)->getStyle('E'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(1)->getStyle('E'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(1)->getStyle('F'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(1)->getStyle('F'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(1)->getStyle('F'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(1)->getStyle('F'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(1)->getStyle('G'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(1)->getStyle('G'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(1)->getStyle('G'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(1)->getStyle('G'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(1)->getStyle('H'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(1)->getStyle('H'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(1)->getStyle('H'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(1)->getStyle('H'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(1)->getStyle('I'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(1)->getStyle('I'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(1)->getStyle('I'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(1)->getStyle('I'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(1)->getStyle('J'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(1)->getStyle('J'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(1)->getStyle('J'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(1)->getStyle('J'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					
					$objPHPExcel->getActiveSheet(1)->setCellValue('A'.$numb, $no);
					$objPHPExcel->getActiveSheet(1)->setCellValue('B'.$numb, date('d-m-Y',strtotime($row["TANGGAL"])));
					$objPHPExcel->getActiveSheet(1)->setCellValue('C'.$numb, $row["NAMA"]);
					$objPHPExcel->getActiveSheet(1)->setCellValue('D'.$numb, $row["NO_TELEPON"]);
					$objPHPExcel->getActiveSheet(1)->setCellValue('E'.$numb, $row["EMAIL"]);
					$objPHPExcel->getActiveSheet(1)->setCellValue('F'.$numb, $row["NO_UPTSA"]);
					$objPHPExcel->getActiveSheet(1)->setCellValue('G'.$numb, $row["NAMA_IJIN"]);
					$objPHPExcel->getActiveSheet(1)->setCellValue('H'.$numb, $row["ISI"]);
					$objPHPExcel->getActiveSheet(1)->getStyle('H'.$numb)->getAlignment()->setWrapText(true);
					$string = "";
					$i = 0;
					foreach($get_proses as $row){
						$get_dates = "";
						if(date('m',strtotime($row["TANGGAL"])) == 1){
							$get_dates = "Januari";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 2){
							$get_date = "Februari";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 3){
							$get_dates = "Maret";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 4){
							$get_dates = "April";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 5){
							$get_dates = "Mei";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 6){
							$get_dates = "Juni";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 7){
							$get_dates = "Juli";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 8){
							$get_dates = "Agustus";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 9){
							$get_dates = "September";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 10){
							$get_dates = "Oktober";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 11){
							$get_dates = "November";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 12){
							$get_dates = "Desember";
						}
						$string .= " > ".date('d',strtotime($row["TANGGAL"]))." ".$get_dates." ".date('Y',strtotime($row["TANGGAL"])).", ".$row["KETERANGAN"]."\n";
						$i++;
					};
					$objPHPExcel->getActiveSheet(1)->setCellValue('I'.$numb, $string);
					$objPHPExcel->getActiveSheet(1)->getStyle('I'.$numb)->getAlignment()->setWrapText(true);
					$objPHPExcel->getActiveSheet(1)->getStyle('I'.$numb)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
					$string2 = "";
					$j = 0;
					foreach($get_verifikasi as $row){
						$get_dates = "";
						if(date('m',strtotime($row["TANGGAL"])) == 1){
							$get_dates = "Januari";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 2){
							$get_date = "Februari";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 3){
							$get_dates = "Maret";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 4){
							$get_dates = "April";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 5){
							$get_dates = "Mei";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 6){
							$get_dates = "Juni";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 7){
							$get_dates = "Juli";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 8){
							$get_dates = "Agustus";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 9){
							$get_dates = "September";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 10){
							$get_dates = "Oktober";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 11){
							$get_dates = "November";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 12){
							$get_dates = "Desember";
						}
						$string2 .= $row["KETERANGAN"]."\n"."Tgl, ".date('d',strtotime($row["TANGGAL"]))." ".$get_dates." ".date('Y',strtotime($row["TANGGAL"]));
						$i++;
					};
					$objPHPExcel->getActiveSheet(1)->setCellValue('J'.$numb, $status."\n".$string2);
					$objPHPExcel->getActiveSheet(1)->getStyle('J'.$numb)->getAlignment()->setWrapText(true);
					$numb++;
					$no++;
				}
				
				//ijin IMB
				$objPHPExcel->createSheet(2);
				$objPHPExcel->getSheet(2)->setTitle('IMB');
				
				$objPHPExcel->setActiveSheetIndex(2);
				
				$objPHPExcel->setActiveSheetIndex(2)->mergeCells('A1:J1');
				$objPHPExcel->setActiveSheetIndex(2)->mergeCells('A2:J2');
				$objPHPExcel->setActiveSheetIndex(2)->mergeCells('B4:C4');
			
				$objPHPExcel->getActiveSheet(2)->getColumnDimension('A')->setAutoSize(true);
				$objPHPExcel->getActiveSheet(2)->getColumnDimension('B')->setAutoSize(true);
				$objPHPExcel->getActiveSheet(2)->getColumnDimension('C')->setAutoSize(true);
				$objPHPExcel->getActiveSheet(2)->getColumnDimension('D')->setAutoSize(true);
				$objPHPExcel->getActiveSheet(2)->getColumnDimension('E')->setAutoSize(true);
				$objPHPExcel->getActiveSheet(2)->getColumnDimension('F')->setAutoSize(true);
				$objPHPExcel->getActiveSheet(2)->getColumnDimension('G')->setAutoSize(true);
				$objPHPExcel->getActiveSheet(2)->getColumnDimension('H')->setAutoSize(false);
				$objPHPExcel->getActiveSheet(2)->getColumnDimension('H')->setWidth(50);
				$objPHPExcel->getActiveSheet(2)->getColumnDimension('I')->setAutoSize(true);
				$objPHPExcel->getActiveSheet(2)->getColumnDimension('J')->setAutoSize(true);
				
				$objPHPExcel->getDefaultStyle()->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
				
				$objPHPExcel->setActiveSheetIndex(2)->getStyle('A6:J6')->applyFromArray(
					array(
						'fill' => array(
							'type' => PHPExcel_Style_Fill::FILL_SOLID,
							'color' => array('rgb' => 'FFFF00')
						)
					)
				);
				
				
				$objPHPExcel->getActiveSheet(2)->getStyle('A4')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(2)->getStyle('A4')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(2)->getStyle('A4')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(2)->getStyle('A4')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
			
				$objPHPExcel->getActiveSheet(2)->getStyle('A6')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(2)->getStyle('A6')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(2)->getStyle('A6')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(2)->getStyle('A6')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(2)->getStyle('B6')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(2)->getStyle('B6')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(2)->getStyle('B6')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(2)->getStyle('B6')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(2)->getStyle('C6')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(2)->getStyle('C6')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(2)->getStyle('C6')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(2)->getStyle('C6')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(2)->getStyle('D6')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(2)->getStyle('D6')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(2)->getStyle('D6')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(2)->getStyle('D6')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(2)->getStyle('E6')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(2)->getStyle('E6')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(2)->getStyle('E6')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(2)->getStyle('E6')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(2)->getStyle('F6')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(2)->getStyle('F6')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(2)->getStyle('F6')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(2)->getStyle('F6')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(2)->getStyle('G6')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(2)->getStyle('G6')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(2)->getStyle('G6')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(2)->getStyle('G6')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(2)->getStyle('H6')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(2)->getStyle('H6')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(2)->getStyle('H6')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(2)->getStyle('H6')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(2)->getStyle('I6')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(2)->getStyle('I6')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(2)->getStyle('I6')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(2)->getStyle('I6')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(2)->getStyle('J6')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(2)->getStyle('J6')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(2)->getStyle('J6')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(2)->getStyle('J6')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
			
				$objPHPExcel->getActiveSheet(2)->getStyle('A1')->getFont()->setSize(22);
				$objPHPExcel->getActiveSheet(2)->getStyle('A2')->getFont()->setSize(12);
				$objPHPExcel->getActiveSheet(2)->getStyle('B4')->getFont()->setSize(12);
				$objPHPExcel->getActiveSheet(2)->getStyle('A1')->getFont()->setBold(true);
				$objPHPExcel->getActiveSheet(2)->getStyle('A6:J6')->getFont()->setBold(true);
				
				$objPHPExcel->getActiveSheet(2)->setCellValue('A1', "LAPORAN PENANGANAN KOMPLAIN");
				$objPHPExcel->getActiveSheet(2)->setCellValue('A2', "Tanggal Pelaporan : ".date('d-m-Y',strtotime($get_taw))." - ".date('d-m-Y',strtotime($get_tak)));
				$objPHPExcel->getActiveSheet(2)->setCellValue('B4', "Bulan : ".$get_date." ".date('Y'));
				
				$objPHPExcel->getActiveSheet(2)->setCellValue('A6', "No");
				$objPHPExcel->getActiveSheet(2)->setCellValue('B6', "Tanggal");
				$objPHPExcel->getActiveSheet(2)->setCellValue('C6', "Nama Pemohon / Pelapor");
				$objPHPExcel->getActiveSheet(2)->setCellValue('D6', "No. Telepon");
				$objPHPExcel->getActiveSheet(2)->setCellValue('E6', "Email");
				$objPHPExcel->getActiveSheet(2)->setCellValue('F6', "No. UPTSA");
				$objPHPExcel->getActiveSheet(2)->setCellValue('G6', "Ijin yang diajukan");
				$objPHPExcel->getActiveSheet(2)->setCellValue('H6', "Isi Komplain");
				$objPHPExcel->getActiveSheet(2)->setCellValue('I6', "Keterangan");
				$objPHPExcel->getActiveSheet(2)->setCellValue('J6', "Verifikasi");
				
				$no 		= 1;
				$numb 		= 7;
				$status		= "";
				foreach($get_dapen_imb as $row)
				{
					$get_proses 	= $this->m_proses_pengaduan_saran->get_proses($row["KD_LIST_PENGADUAN"]);
					$get_verifikasi	= $this->m_proses_pengaduan_saran->get_verifikasi($row["KD_LIST_PENGADUAN"]);
					if($row["STATUS"] == 1)
					{
						$status = "SELESAI";
					}
					elseif($row["STATUS"] == 2)
					{
						$status = "PROSES";
					}
				
					$objPHPExcel->getActiveSheet(2)->getStyle('A'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(2)->getStyle('A'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(2)->getStyle('A'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(2)->getStyle('A'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(2)->getStyle('B'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(2)->getStyle('B'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(2)->getStyle('B'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(2)->getStyle('B'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(2)->getStyle('C'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(2)->getStyle('C'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(2)->getStyle('C'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(2)->getStyle('C'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(2)->getStyle('D'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(2)->getStyle('D'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(2)->getStyle('D'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(2)->getStyle('D'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(2)->getStyle('E'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(2)->getStyle('E'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(2)->getStyle('E'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(2)->getStyle('E'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(2)->getStyle('F'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(2)->getStyle('F'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(2)->getStyle('F'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(2)->getStyle('F'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(2)->getStyle('G'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(2)->getStyle('G'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(2)->getStyle('G'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(2)->getStyle('G'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(2)->getStyle('H'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(2)->getStyle('H'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(2)->getStyle('H'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(2)->getStyle('H'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(2)->getStyle('I'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(2)->getStyle('I'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(2)->getStyle('I'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(2)->getStyle('I'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(2)->getStyle('J'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(2)->getStyle('J'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(2)->getStyle('J'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(2)->getStyle('J'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					
					$objPHPExcel->getActiveSheet(2)->setCellValue('A'.$numb, $no);
					$objPHPExcel->getActiveSheet(2)->setCellValue('B'.$numb, date('d-m-Y',strtotime($row["TANGGAL"])));
					$objPHPExcel->getActiveSheet(2)->setCellValue('C'.$numb, $row["NAMA"]);
					$objPHPExcel->getActiveSheet(2)->setCellValue('D'.$numb, $row["NO_TELEPON"]);
					$objPHPExcel->getActiveSheet(2)->setCellValue('E'.$numb, $row["EMAIL"]);
					$objPHPExcel->getActiveSheet(2)->setCellValue('F'.$numb, $row["NO_UPTSA"]);
					$objPHPExcel->getActiveSheet(2)->setCellValue('G'.$numb, $row["NAMA_IJIN"]);
					$objPHPExcel->getActiveSheet(2)->setCellValue('H'.$numb, $row["ISI"]);
					$objPHPExcel->getActiveSheet(2)->getStyle('H'.$numb)->getAlignment()->setWrapText(true);
					$string = "";
					$i = 0;
					foreach($get_proses as $row){
						$get_dates = "";
						if(date('m',strtotime($row["TANGGAL"])) == 1){
							$get_dates = "Januari";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 2){
							$get_date = "Februari";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 3){
							$get_dates = "Maret";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 4){
							$get_dates = "April";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 5){
							$get_dates = "Mei";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 6){
							$get_dates = "Juni";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 7){
							$get_dates = "Juli";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 8){
							$get_dates = "Agustus";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 9){
							$get_dates = "September";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 10){
							$get_dates = "Oktober";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 11){
							$get_dates = "November";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 12){
							$get_dates = "Desember";
						}
						$string .= " > ".date('d',strtotime($row["TANGGAL"]))." ".$get_dates." ".date('Y',strtotime($row["TANGGAL"])).", ".$row["KETERANGAN"]."\n";
						$i++;
					};
					$objPHPExcel->getActiveSheet(2)->setCellValue('I'.$numb, $string);
					$objPHPExcel->getActiveSheet(2)->getStyle('I'.$numb)->getAlignment()->setWrapText(true);
					$objPHPExcel->getActiveSheet(2)->getStyle('I'.$numb)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
					$string2 = "";
					$j = 0;
					foreach($get_verifikasi as $row){
						$get_dates = "";
						if(date('m',strtotime($row["TANGGAL"])) == 1){
							$get_dates = "Januari";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 2){
							$get_date = "Februari";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 3){
							$get_dates = "Maret";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 4){
							$get_dates = "April";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 5){
							$get_dates = "Mei";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 6){
							$get_dates = "Juni";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 7){
							$get_dates = "Juli";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 8){
							$get_dates = "Agustus";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 9){
							$get_dates = "September";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 10){
							$get_dates = "Oktober";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 11){
							$get_dates = "November";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 12){
							$get_dates = "Desember";
						}
						$string2 .= $row["KETERANGAN"]."\n"."Tgl, ".date('d',strtotime($row["TANGGAL"]))." ".$get_dates." ".date('Y',strtotime($row["TANGGAL"]));
						$i++;
					};
					$objPHPExcel->getActiveSheet(2)->setCellValue('J'.$numb, $status."\n".$string2);
					$objPHPExcel->getActiveSheet(2)->getStyle('J'.$numb)->getAlignment()->setWrapText(true);
					$numb++;
					$no++;
				}
				
				//ijin HO
				$objPHPExcel->createSheet(3);
				$objPHPExcel->getSheet(3)->setTitle('HO');
				
				$objPHPExcel->setActiveSheetIndex(3);
				
				$objPHPExcel->setActiveSheetIndex(3)->mergeCells('A1:J1');
				$objPHPExcel->setActiveSheetIndex(3)->mergeCells('A2:J2');
				$objPHPExcel->setActiveSheetIndex(3)->mergeCells('B4:C4');
			
				$objPHPExcel->getActiveSheet(3)->getColumnDimension('A')->setAutoSize(true);
				$objPHPExcel->getActiveSheet(3)->getColumnDimension('B')->setAutoSize(true);
				$objPHPExcel->getActiveSheet(3)->getColumnDimension('C')->setAutoSize(true);
				$objPHPExcel->getActiveSheet(3)->getColumnDimension('D')->setAutoSize(true);
				$objPHPExcel->getActiveSheet(3)->getColumnDimension('E')->setAutoSize(true);
				$objPHPExcel->getActiveSheet(3)->getColumnDimension('F')->setAutoSize(true);
				$objPHPExcel->getActiveSheet(3)->getColumnDimension('G')->setAutoSize(true);
				$objPHPExcel->getActiveSheet(3)->getColumnDimension('H')->setAutoSize(false);
				$objPHPExcel->getActiveSheet(3)->getColumnDimension('H')->setWidth(50);
				$objPHPExcel->getActiveSheet(3)->getColumnDimension('I')->setAutoSize(true);
				$objPHPExcel->getActiveSheet(3)->getColumnDimension('J')->setAutoSize(true);
				
				$objPHPExcel->getDefaultStyle()->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
				
				$objPHPExcel->setActiveSheetIndex(3)->getStyle('A6:J6')->applyFromArray(
					array(
						'fill' => array(
							'type' => PHPExcel_Style_Fill::FILL_SOLID,
							'color' => array('rgb' => 'FFFF00')
						)
					)
				);
				
				
				$objPHPExcel->getActiveSheet(3)->getStyle('A4')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(3)->getStyle('A4')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(3)->getStyle('A4')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(3)->getStyle('A4')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
		
				$objPHPExcel->getActiveSheet(3)->getStyle('A6')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(3)->getStyle('A6')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(3)->getStyle('A6')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(3)->getStyle('A6')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(3)->getStyle('B6')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(3)->getStyle('B6')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(3)->getStyle('B6')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(3)->getStyle('B6')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(3)->getStyle('C6')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(3)->getStyle('C6')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(3)->getStyle('C6')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(3)->getStyle('C6')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(3)->getStyle('D6')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(3)->getStyle('D6')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(3)->getStyle('D6')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(3)->getStyle('D6')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(3)->getStyle('E6')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(3)->getStyle('E6')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(3)->getStyle('E6')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(3)->getStyle('E6')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(3)->getStyle('F6')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(3)->getStyle('F6')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(3)->getStyle('F6')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(3)->getStyle('F6')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(3)->getStyle('G6')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(3)->getStyle('G6')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(3)->getStyle('G6')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(3)->getStyle('G6')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(3)->getStyle('H6')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(3)->getStyle('H6')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(3)->getStyle('H6')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(3)->getStyle('H6')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(3)->getStyle('I6')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(3)->getStyle('I6')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(3)->getStyle('I6')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(3)->getStyle('I6')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(3)->getStyle('J6')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(3)->getStyle('J6')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(3)->getStyle('J6')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(3)->getStyle('J6')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
		
				$objPHPExcel->getActiveSheet(3)->getStyle('A1')->getFont()->setSize(22);
				$objPHPExcel->getActiveSheet(3)->getStyle('A2')->getFont()->setSize(12);
				$objPHPExcel->getActiveSheet(3)->getStyle('B4')->getFont()->setSize(12);
				$objPHPExcel->getActiveSheet(3)->getStyle('A1')->getFont()->setBold(true);
				$objPHPExcel->getActiveSheet(3)->getStyle('A6:J6')->getFont()->setBold(true);
				
				$objPHPExcel->getActiveSheet(3)->setCellValue('A1', "LAPORAN PENANGANAN KOMPLAIN");
				$objPHPExcel->getActiveSheet(3)->setCellValue('A2', "Tanggal Pelaporan : ".date('d-m-Y',strtotime($get_taw))." - ".date('d-m-Y',strtotime($get_tak)));
				$objPHPExcel->getActiveSheet(3)->setCellValue('B4', "Bulan : ".$get_date." ".date('Y'));
				
				$objPHPExcel->getActiveSheet(3)->setCellValue('A6', "No");
				$objPHPExcel->getActiveSheet(3)->setCellValue('B6', "Tanggal");
				$objPHPExcel->getActiveSheet(3)->setCellValue('C6', "Nama Pemohon / Pelapor");
				$objPHPExcel->getActiveSheet(3)->setCellValue('D6', "No. Telepon");
				$objPHPExcel->getActiveSheet(3)->setCellValue('E6', "Email");
				$objPHPExcel->getActiveSheet(3)->setCellValue('F6', "No. UPTSA");
				$objPHPExcel->getActiveSheet(3)->setCellValue('G6', "Ijin yang diajukan");
				$objPHPExcel->getActiveSheet(3)->setCellValue('H6', "Isi Komplain");
				$objPHPExcel->getActiveSheet(3)->setCellValue('I6', "Keterangan");
				$objPHPExcel->getActiveSheet(3)->setCellValue('J6', "Verifikasi");
			
				$no 		= 1;
				$numb 		= 7;
				$status		= "";
				foreach($get_dapen_ho as $row)
				{
					$get_proses 	= $this->m_proses_pengaduan_saran->get_proses($row["KD_LIST_PENGADUAN"]);
					$get_verifikasi	= $this->m_proses_pengaduan_saran->get_verifikasi($row["KD_LIST_PENGADUAN"]);
					if($row["STATUS"] == 1)
					{
						$status = "SELESAI";
					}
					elseif($row["STATUS"] == 2)
					{
						$status = "PROSES";
					}
				
					$objPHPExcel->getActiveSheet(3)->getStyle('A'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(3)->getStyle('A'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(3)->getStyle('A'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(3)->getStyle('A'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(3)->getStyle('B'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(3)->getStyle('B'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(3)->getStyle('B'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(3)->getStyle('B'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(3)->getStyle('C'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(3)->getStyle('C'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(3)->getStyle('C'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(3)->getStyle('C'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(3)->getStyle('D'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(3)->getStyle('D'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(3)->getStyle('D'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(3)->getStyle('D'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(3)->getStyle('E'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(3)->getStyle('E'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(3)->getStyle('E'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(3)->getStyle('E'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(3)->getStyle('F'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(3)->getStyle('F'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(3)->getStyle('F'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(3)->getStyle('F'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(3)->getStyle('G'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(3)->getStyle('G'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(3)->getStyle('G'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(3)->getStyle('G'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(3)->getStyle('H'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(3)->getStyle('H'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(3)->getStyle('H'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(3)->getStyle('H'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(3)->getStyle('I'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(3)->getStyle('I'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(3)->getStyle('I'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(3)->getStyle('I'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(3)->getStyle('J'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(3)->getStyle('J'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(3)->getStyle('J'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(3)->getStyle('J'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				
					$objPHPExcel->getActiveSheet(3)->setCellValue('A'.$numb, $no);
					$objPHPExcel->getActiveSheet(3)->setCellValue('B'.$numb, date('d-m-Y',strtotime($row["TANGGAL"])));
					$objPHPExcel->getActiveSheet(3)->setCellValue('C'.$numb, $row["NAMA"]);
					$objPHPExcel->getActiveSheet(3)->setCellValue('D'.$numb, $row["NO_TELEPON"]);
					$objPHPExcel->getActiveSheet(3)->setCellValue('E'.$numb, $row["EMAIL"]);
					$objPHPExcel->getActiveSheet(3)->setCellValue('F'.$numb, $row["NO_UPTSA"]);
					$objPHPExcel->getActiveSheet(3)->setCellValue('G'.$numb, $row["NAMA_IJIN"]);
					$objPHPExcel->getActiveSheet(3)->setCellValue('H'.$numb, $row["ISI"]);
					$objPHPExcel->getActiveSheet(3)->getStyle('H'.$numb)->getAlignment()->setWrapText(true);
					$string = "";
					$i = 0;
					foreach($get_proses as $row){
						$get_dates = "";
						if(date('m',strtotime($row["TANGGAL"])) == 1){
							$get_dates = "Januari";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 2){
							$get_date = "Februari";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 3){
							$get_dates = "Maret";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 4){
							$get_dates = "April";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 5){
							$get_dates = "Mei";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 6){
							$get_dates = "Juni";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 7){
							$get_dates = "Juli";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 8){
							$get_dates = "Agustus";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 9){
							$get_dates = "September";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 10){
							$get_dates = "Oktober";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 11){
							$get_dates = "November";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 12){
							$get_dates = "Desember";
						}
						$string .= " > ".date('d',strtotime($row["TANGGAL"]))." ".$get_dates." ".date('Y',strtotime($row["TANGGAL"])).", ".$row["KETERANGAN"]."\n";
						$i++;
					};
					$objPHPExcel->getActiveSheet(3)->setCellValue('I'.$numb, $string);
					$objPHPExcel->getActiveSheet(3)->getStyle('I'.$numb)->getAlignment()->setWrapText(true);
					$objPHPExcel->getActiveSheet(3)->getStyle('I'.$numb)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
					$string2 = "";
					$j = 0;
					foreach($get_verifikasi as $row){
						$get_dates = "";
						if(date('m',strtotime($row["TANGGAL"])) == 1){
							$get_dates = "Januari";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 2){
							$get_date = "Februari";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 3){
							$get_dates = "Maret";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 4){
							$get_dates = "April";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 5){
							$get_dates = "Mei";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 6){
							$get_dates = "Juni";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 7){
							$get_dates = "Juli";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 8){
							$get_dates = "Agustus";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 9){
							$get_dates = "September";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 10){
							$get_dates = "Oktober";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 11){
							$get_dates = "November";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 12){
							$get_dates = "Desember";
						}
						$string2 .= $row["KETERANGAN"]."\n"."Tgl, ".date('d',strtotime($row["TANGGAL"]))." ".$get_dates." ".date('Y',strtotime($row["TANGGAL"]));
						$i++;
					};
					$objPHPExcel->getActiveSheet(3)->setCellValue('J'.$numb, $status."\n".$string2);
					$objPHPExcel->getActiveSheet(3)->getStyle('J'.$numb)->getAlignment()->setWrapText(true);
					$numb++;
					$no++;
				}
				
				//ijin TDUP
				$objPHPExcel->createSheet(4);
				$objPHPExcel->getSheet(4)->setTitle('TDUP');
				
				$objPHPExcel->setActiveSheetIndex(4);
				
				$objPHPExcel->setActiveSheetIndex(4)->mergeCells('A1:J1');
				$objPHPExcel->setActiveSheetIndex(4)->mergeCells('A2:J2');
				$objPHPExcel->setActiveSheetIndex(4)->mergeCells('B4:C4');
			
				$objPHPExcel->getActiveSheet(4)->getColumnDimension('A')->setAutoSize(true);
				$objPHPExcel->getActiveSheet(4)->getColumnDimension('B')->setAutoSize(true);
				$objPHPExcel->getActiveSheet(4)->getColumnDimension('C')->setAutoSize(true);
				$objPHPExcel->getActiveSheet(4)->getColumnDimension('D')->setAutoSize(true);
				$objPHPExcel->getActiveSheet(4)->getColumnDimension('E')->setAutoSize(true);
				$objPHPExcel->getActiveSheet(4)->getColumnDimension('F')->setAutoSize(true);
				$objPHPExcel->getActiveSheet(4)->getColumnDimension('G')->setAutoSize(true);
				$objPHPExcel->getActiveSheet(4)->getColumnDimension('H')->setAutoSize(false);
				$objPHPExcel->getActiveSheet(4)->getColumnDimension('H')->setWidth(50);
				$objPHPExcel->getActiveSheet(4)->getColumnDimension('I')->setAutoSize(true);
				$objPHPExcel->getActiveSheet(4)->getColumnDimension('J')->setAutoSize(true);
				
				$objPHPExcel->getDefaultStyle()->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
				
				$objPHPExcel->setActiveSheetIndex(4)->getStyle('A6:J6')->applyFromArray(
					array(
						'fill' => array(
							'type' => PHPExcel_Style_Fill::FILL_SOLID,
							'color' => array('rgb' => 'FFFF00')
						)
					)
				);
				
				
				$objPHPExcel->getActiveSheet(4)->getStyle('A4')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(4)->getStyle('A4')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(4)->getStyle('A4')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(4)->getStyle('A4')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
		
				$objPHPExcel->getActiveSheet(4)->getStyle('A6')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(4)->getStyle('A6')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(4)->getStyle('A6')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(4)->getStyle('A6')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(4)->getStyle('B6')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(4)->getStyle('B6')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(4)->getStyle('B6')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(4)->getStyle('B6')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(4)->getStyle('C6')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(4)->getStyle('C6')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(4)->getStyle('C6')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(4)->getStyle('C6')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(4)->getStyle('D6')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(4)->getStyle('D6')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(4)->getStyle('D6')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(4)->getStyle('D6')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(4)->getStyle('E6')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(4)->getStyle('E6')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(4)->getStyle('E6')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(4)->getStyle('E6')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(4)->getStyle('F6')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(4)->getStyle('F6')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(4)->getStyle('F6')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(4)->getStyle('F6')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(4)->getStyle('G6')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(4)->getStyle('G6')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(4)->getStyle('G6')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(4)->getStyle('G6')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(4)->getStyle('H6')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(4)->getStyle('H6')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(4)->getStyle('H6')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(4)->getStyle('H6')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(4)->getStyle('I6')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(4)->getStyle('I6')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(4)->getStyle('I6')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(4)->getStyle('I6')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(4)->getStyle('J6')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(4)->getStyle('J6')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(4)->getStyle('J6')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(4)->getStyle('J6')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
	
				$objPHPExcel->getActiveSheet(4)->getStyle('A1')->getFont()->setSize(22);
				$objPHPExcel->getActiveSheet(4)->getStyle('A2')->getFont()->setSize(12);
				$objPHPExcel->getActiveSheet(4)->getStyle('B4')->getFont()->setSize(12);
				$objPHPExcel->getActiveSheet(4)->getStyle('A1')->getFont()->setBold(true);
				$objPHPExcel->getActiveSheet(4)->getStyle('A6:J6')->getFont()->setBold(true);
				
				$objPHPExcel->getActiveSheet(4)->setCellValue('A1', "LAPORAN PENANGANAN KOMPLAIN");
				$objPHPExcel->getActiveSheet(4)->setCellValue('A2', "Tanggal Pelaporan : ".date('d-m-Y',strtotime($get_taw))." - ".date('d-m-Y',strtotime($get_tak)));
				$objPHPExcel->getActiveSheet(4)->setCellValue('B4', "Bulan : ".$get_date." ".date('Y'));
			
				$objPHPExcel->getActiveSheet(4)->setCellValue('A6', "No");
				$objPHPExcel->getActiveSheet(4)->setCellValue('B6', "Tanggal");
				$objPHPExcel->getActiveSheet(4)->setCellValue('C6', "Nama Pemohon / Pelapor");
				$objPHPExcel->getActiveSheet(4)->setCellValue('D6', "No. Telepon");
				$objPHPExcel->getActiveSheet(4)->setCellValue('E6', "Email");
				$objPHPExcel->getActiveSheet(4)->setCellValue('F6', "No. UPTSA");
				$objPHPExcel->getActiveSheet(4)->setCellValue('G6', "Ijin yang diajukan");
				$objPHPExcel->getActiveSheet(4)->setCellValue('H6', "Isi Komplain");
				$objPHPExcel->getActiveSheet(4)->setCellValue('I6', "Keterangan");
				$objPHPExcel->getActiveSheet(4)->setCellValue('J6', "Verifikasi");
			
				$no 		= 1;
				$numb 		= 7;
				$status		= "";
				foreach($get_dapen_tdup as $row)
				{
					$get_proses 	= $this->m_proses_pengaduan_saran->get_proses($row["KD_LIST_PENGADUAN"]);
					$get_verifikasi	= $this->m_proses_pengaduan_saran->get_verifikasi($row["KD_LIST_PENGADUAN"]);
					if($row["STATUS"] == 1)
					{
						$status = "SELESAI";
					}
					elseif($row["STATUS"] == 2)
					{
						$status = "PROSES";
					}
				
					$objPHPExcel->getActiveSheet(4)->getStyle('A'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(4)->getStyle('A'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(4)->getStyle('A'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(4)->getStyle('A'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(4)->getStyle('B'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(4)->getStyle('B'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(4)->getStyle('B'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(4)->getStyle('B'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(4)->getStyle('C'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(4)->getStyle('C'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(4)->getStyle('C'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(4)->getStyle('C'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(4)->getStyle('D'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(4)->getStyle('D'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(4)->getStyle('D'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(4)->getStyle('D'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(4)->getStyle('E'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(4)->getStyle('E'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(4)->getStyle('E'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(4)->getStyle('E'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(4)->getStyle('F'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(4)->getStyle('F'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(4)->getStyle('F'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(4)->getStyle('F'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(4)->getStyle('G'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(4)->getStyle('G'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(4)->getStyle('G'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(4)->getStyle('G'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(4)->getStyle('H'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(4)->getStyle('H'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(4)->getStyle('H'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(4)->getStyle('H'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(4)->getStyle('I'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(4)->getStyle('I'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(4)->getStyle('I'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(4)->getStyle('I'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(4)->getStyle('J'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(4)->getStyle('J'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(4)->getStyle('J'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(4)->getStyle('J'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
			
					$objPHPExcel->getActiveSheet(4)->setCellValue('A'.$numb, $no);
					$objPHPExcel->getActiveSheet(4)->setCellValue('B'.$numb, date('d-m-Y',strtotime($row["TANGGAL"])));
					$objPHPExcel->getActiveSheet(4)->setCellValue('C'.$numb, $row["NAMA"]);
					$objPHPExcel->getActiveSheet(4)->setCellValue('D'.$numb, $row["NO_TELEPON"]);
					$objPHPExcel->getActiveSheet(4)->setCellValue('E'.$numb, $row["EMAIL"]);
					$objPHPExcel->getActiveSheet(4)->setCellValue('F'.$numb, $row["NO_UPTSA"]);
					$objPHPExcel->getActiveSheet(4)->setCellValue('G'.$numb, $row["NAMA_IJIN"]);
					$objPHPExcel->getActiveSheet(4)->setCellValue('H'.$numb, $row["ISI"]);
					$objPHPExcel->getActiveSheet(4)->getStyle('H'.$numb)->getAlignment()->setWrapText(true);
					$string = "";
					$i = 0;
					foreach($get_proses as $row){
						$get_dates = "";
						if(date('m',strtotime($row["TANGGAL"])) == 1){
							$get_dates = "Januari";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 2){
							$get_date = "Februari";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 3){
							$get_dates = "Maret";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 4){
							$get_dates = "April";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 5){
							$get_dates = "Mei";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 6){
							$get_dates = "Juni";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 7){
							$get_dates = "Juli";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 8){
							$get_dates = "Agustus";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 9){
							$get_dates = "September";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 10){
							$get_dates = "Oktober";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 11){
							$get_dates = "November";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 12){
							$get_dates = "Desember";
						}
						$string .= " > ".date('d',strtotime($row["TANGGAL"]))." ".$get_dates." ".date('Y',strtotime($row["TANGGAL"])).", ".$row["KETERANGAN"]."\n";
						$i++;
					};
					$objPHPExcel->getActiveSheet(4)->setCellValue('I'.$numb, $string);
					$objPHPExcel->getActiveSheet(4)->getStyle('I'.$numb)->getAlignment()->setWrapText(true);
					$objPHPExcel->getActiveSheet(4)->getStyle('I'.$numb)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
					$string2 = "";
					$j = 0;
					foreach($get_verifikasi as $row){
						$get_dates = "";
						if(date('m',strtotime($row["TANGGAL"])) == 1){
							$get_dates = "Januari";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 2){
							$get_date = "Februari";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 3){
							$get_dates = "Maret";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 4){
							$get_dates = "April";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 5){
							$get_dates = "Mei";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 6){
							$get_dates = "Juni";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 7){
							$get_dates = "Juli";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 8){
							$get_dates = "Agustus";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 9){
							$get_dates = "September";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 10){
							$get_dates = "Oktober";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 11){
							$get_dates = "November";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 12){
							$get_dates = "Desember";
						}
						$string2 .= $row["KETERANGAN"]."\n"."Tgl, ".date('d',strtotime($row["TANGGAL"]))." ".$get_dates." ".date('Y',strtotime($row["TANGGAL"]));
						$i++;
					};
					$objPHPExcel->getActiveSheet(4)->setCellValue('J'.$numb, $status."\n".$string2);
					$objPHPExcel->getActiveSheet(4)->getStyle('J'.$numb)->getAlignment()->setWrapText(true);
					$numb++;
					$no++;
				}
				
				//ijin SSW
				$objPHPExcel->createSheet(5);
				$objPHPExcel->getSheet(5)->setTitle('SSW (Paket)');
				
				$objPHPExcel->setActiveSheetIndex(5);
				
				$objPHPExcel->setActiveSheetIndex(5)->mergeCells('A1:J1');
				$objPHPExcel->setActiveSheetIndex(5)->mergeCells('A2:J2');
				$objPHPExcel->setActiveSheetIndex(5)->mergeCells('B4:C4');
			
				$objPHPExcel->getActiveSheet(5)->getColumnDimension('A')->setAutoSize(true);
				$objPHPExcel->getActiveSheet(5)->getColumnDimension('B')->setAutoSize(true);
				$objPHPExcel->getActiveSheet(5)->getColumnDimension('C')->setAutoSize(true);
				$objPHPExcel->getActiveSheet(5)->getColumnDimension('D')->setAutoSize(true);
				$objPHPExcel->getActiveSheet(5)->getColumnDimension('E')->setAutoSize(true);
				$objPHPExcel->getActiveSheet(5)->getColumnDimension('F')->setAutoSize(true);
				$objPHPExcel->getActiveSheet(5)->getColumnDimension('G')->setAutoSize(true);
				$objPHPExcel->getActiveSheet(5)->getColumnDimension('H')->setAutoSize(false);
				$objPHPExcel->getActiveSheet(5)->getColumnDimension('H')->setWidth(50);
				$objPHPExcel->getActiveSheet(5)->getColumnDimension('I')->setAutoSize(true);
				$objPHPExcel->getActiveSheet(5)->getColumnDimension('J')->setAutoSize(true);
				
				$objPHPExcel->getDefaultStyle()->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
				
				$objPHPExcel->setActiveSheetIndex(5)->getStyle('A6:J6')->applyFromArray(
					array(
						'fill' => array(
							'type' => PHPExcel_Style_Fill::FILL_SOLID,
							'color' => array('rgb' => 'FFFF00')
						)
					)
				);
				
				
				$objPHPExcel->getActiveSheet(5)->getStyle('A4')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(5)->getStyle('A4')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(5)->getStyle('A4')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(5)->getStyle('A4')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
	
				$objPHPExcel->getActiveSheet(5)->getStyle('A6')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(5)->getStyle('A6')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(5)->getStyle('A6')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(5)->getStyle('A6')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(5)->getStyle('B6')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(5)->getStyle('B6')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(5)->getStyle('B6')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(5)->getStyle('B6')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(5)->getStyle('C6')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(5)->getStyle('C6')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(5)->getStyle('C6')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(5)->getStyle('C6')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(5)->getStyle('D6')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(5)->getStyle('D6')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(5)->getStyle('D6')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(5)->getStyle('D6')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(5)->getStyle('E6')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(5)->getStyle('E6')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(5)->getStyle('E6')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(5)->getStyle('E6')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(5)->getStyle('F6')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(5)->getStyle('F6')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(5)->getStyle('F6')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(5)->getStyle('F6')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(5)->getStyle('G6')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(5)->getStyle('G6')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(5)->getStyle('G6')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(5)->getStyle('G6')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(5)->getStyle('H6')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(5)->getStyle('H6')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(5)->getStyle('H6')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(5)->getStyle('H6')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(5)->getStyle('I6')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(5)->getStyle('I6')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(5)->getStyle('I6')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(5)->getStyle('I6')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(5)->getStyle('J6')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(5)->getStyle('J6')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(5)->getStyle('J6')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(5)->getStyle('J6')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
	
				$objPHPExcel->getActiveSheet(5)->getStyle('A1')->getFont()->setSize(22);
				$objPHPExcel->getActiveSheet(5)->getStyle('A2')->getFont()->setSize(12);
				$objPHPExcel->getActiveSheet(5)->getStyle('B4')->getFont()->setSize(12);
				$objPHPExcel->getActiveSheet(5)->getStyle('A1')->getFont()->setBold(true);
				$objPHPExcel->getActiveSheet(5)->getStyle('A6:J6')->getFont()->setBold(true);
			
				$objPHPExcel->getActiveSheet(5)->setCellValue('A1', "LAPORAN PENANGANAN KOMPLAIN");
				$objPHPExcel->getActiveSheet(5)->setCellValue('A2', "Tanggal Pelaporan : ".date('d-m-Y',strtotime($get_taw))." - ".date('d-m-Y',strtotime($get_tak)));
				$objPHPExcel->getActiveSheet(5)->setCellValue('B4', "Bulan : ".$get_date." ".date('Y'));
		
				$objPHPExcel->getActiveSheet(5)->setCellValue('A6', "No");
				$objPHPExcel->getActiveSheet(5)->setCellValue('B6', "Tanggal");
				$objPHPExcel->getActiveSheet(5)->setCellValue('C6', "Nama Pemohon / Pelapor");
				$objPHPExcel->getActiveSheet(5)->setCellValue('D6', "No. Telepon");
				$objPHPExcel->getActiveSheet(5)->setCellValue('E6', "Email");
				$objPHPExcel->getActiveSheet(5)->setCellValue('F6', "No. UPTSA");
				$objPHPExcel->getActiveSheet(5)->setCellValue('G6', "Ijin yang diajukan");
				$objPHPExcel->getActiveSheet(5)->setCellValue('H6', "Isi Komplain");
				$objPHPExcel->getActiveSheet(5)->setCellValue('I6', "Keterangan");
				$objPHPExcel->getActiveSheet(5)->setCellValue('J6', "Verifikasi");
			
				$no 		= 1;
				$numb 		= 7;
				$status		= "";
				foreach($get_dapen_ssw as $row)
				{
					$get_proses 	= $this->m_proses_pengaduan_saran->get_proses($row["KD_LIST_PENGADUAN"]);
					$get_verifikasi	= $this->m_proses_pengaduan_saran->get_verifikasi($row["KD_LIST_PENGADUAN"]);
					if($row["STATUS"] == 1)
					{
						$status = "SELESAI";
					}
					elseif($row["STATUS"] == 2)
					{
						$status = "PROSES";
					}
				
					$objPHPExcel->getActiveSheet(5)->getStyle('A'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(5)->getStyle('A'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(5)->getStyle('A'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(5)->getStyle('A'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(5)->getStyle('B'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(5)->getStyle('B'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(5)->getStyle('B'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(5)->getStyle('B'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(5)->getStyle('C'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(5)->getStyle('C'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(5)->getStyle('C'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(5)->getStyle('C'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(5)->getStyle('D'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(5)->getStyle('D'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(5)->getStyle('D'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(5)->getStyle('D'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(5)->getStyle('E'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(5)->getStyle('E'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(5)->getStyle('E'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(5)->getStyle('E'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(5)->getStyle('F'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(5)->getStyle('F'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(5)->getStyle('F'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(5)->getStyle('F'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(5)->getStyle('G'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(5)->getStyle('G'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(5)->getStyle('G'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(5)->getStyle('G'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(5)->getStyle('H'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(5)->getStyle('H'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(5)->getStyle('H'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(5)->getStyle('H'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(5)->getStyle('I'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(5)->getStyle('I'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(5)->getStyle('I'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(5)->getStyle('I'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(5)->getStyle('J'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(5)->getStyle('J'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(5)->getStyle('J'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(5)->getStyle('J'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
			
					$objPHPExcel->getActiveSheet(5)->setCellValue('A'.$numb, $no);
					$objPHPExcel->getActiveSheet(5)->setCellValue('B'.$numb, date('d-m-Y',strtotime($row["TANGGAL"])));
					$objPHPExcel->getActiveSheet(5)->setCellValue('C'.$numb, $row["NAMA"]);
					$objPHPExcel->getActiveSheet(5)->setCellValue('D'.$numb, $row["NO_TELEPON"]);
					$objPHPExcel->getActiveSheet(5)->setCellValue('E'.$numb, $row["EMAIL"]);
					$objPHPExcel->getActiveSheet(5)->setCellValue('F'.$numb, $row["NO_UPTSA"]);
					$objPHPExcel->getActiveSheet(5)->setCellValue('G'.$numb, $row["NAMA_IJIN"]);
					$objPHPExcel->getActiveSheet(5)->setCellValue('H'.$numb, $row["ISI"]);
					$objPHPExcel->getActiveSheet(5)->getStyle('H'.$numb)->getAlignment()->setWrapText(true);
					$string = "";
					$i = 0;
					foreach($get_proses as $row){
						$get_dates = "";
						if(date('m',strtotime($row["TANGGAL"])) == 1){
							$get_dates = "Januari";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 2){
							$get_date = "Februari";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 3){
							$get_dates = "Maret";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 4){
							$get_dates = "April";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 5){
							$get_dates = "Mei";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 6){
							$get_dates = "Juni";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 7){
							$get_dates = "Juli";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 8){
							$get_dates = "Agustus";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 9){
							$get_dates = "September";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 10){
							$get_dates = "Oktober";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 11){
							$get_dates = "November";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 12){
							$get_dates = "Desember";
						}
						$string .= " > ".date('d',strtotime($row["TANGGAL"]))." ".$get_dates." ".date('Y',strtotime($row["TANGGAL"])).", ".$row["KETERANGAN"]."\n";
						$i++;
					};
					$objPHPExcel->getActiveSheet(5)->setCellValue('I'.$numb, $string);
					$objPHPExcel->getActiveSheet(5)->getStyle('I'.$numb)->getAlignment()->setWrapText(true);
					$objPHPExcel->getActiveSheet(5)->getStyle('I'.$numb)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
					$string2 = "";
					$j = 0;
					foreach($get_verifikasi as $row){
						$get_dates = "";
						if(date('m',strtotime($row["TANGGAL"])) == 1){
							$get_dates = "Januari";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 2){
							$get_date = "Februari";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 3){
							$get_dates = "Maret";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 4){
							$get_dates = "April";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 5){
							$get_dates = "Mei";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 6){
							$get_dates = "Juni";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 7){
							$get_dates = "Juli";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 8){
							$get_dates = "Agustus";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 9){
							$get_dates = "September";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 10){
							$get_dates = "Oktober";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 11){
							$get_dates = "November";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 12){
							$get_dates = "Desember";
						}
						$string2 .= $row["KETERANGAN"]."\n"."Tgl, ".date('d',strtotime($row["TANGGAL"]))." ".$get_dates." ".date('Y',strtotime($row["TANGGAL"]));
						$i++;
					};
					$objPHPExcel->getActiveSheet(5)->setCellValue('J'.$numb, $status."\n".$string2);
					$objPHPExcel->getActiveSheet(5)->getStyle('J'.$numb)->getAlignment()->setWrapText(true);
					$numb++;
					$no++;
				}
				
				//ijin SIUP
				$objPHPExcel->createSheet(6);
				$objPHPExcel->getSheet(6)->setTitle('SIUP');
				
				$objPHPExcel->setActiveSheetIndex(6);
				
				$objPHPExcel->setActiveSheetIndex(6)->mergeCells('A1:J1');
				$objPHPExcel->setActiveSheetIndex(6)->mergeCells('A2:J2');
				$objPHPExcel->setActiveSheetIndex(6)->mergeCells('B4:C4');
			
				$objPHPExcel->getActiveSheet(6)->getColumnDimension('A')->setAutoSize(true);
				$objPHPExcel->getActiveSheet(6)->getColumnDimension('B')->setAutoSize(true);
				$objPHPExcel->getActiveSheet(6)->getColumnDimension('C')->setAutoSize(true);
				$objPHPExcel->getActiveSheet(6)->getColumnDimension('D')->setAutoSize(true);
				$objPHPExcel->getActiveSheet(6)->getColumnDimension('E')->setAutoSize(true);
				$objPHPExcel->getActiveSheet(6)->getColumnDimension('F')->setAutoSize(true);
				$objPHPExcel->getActiveSheet(6)->getColumnDimension('G')->setAutoSize(true);
				$objPHPExcel->getActiveSheet(6)->getColumnDimension('H')->setAutoSize(false);
				$objPHPExcel->getActiveSheet(6)->getColumnDimension('H')->setWidth(50);
				$objPHPExcel->getActiveSheet(6)->getColumnDimension('I')->setAutoSize(true);
				$objPHPExcel->getActiveSheet(6)->getColumnDimension('J')->setAutoSize(true);
				
				$objPHPExcel->getDefaultStyle()->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
				
				$objPHPExcel->setActiveSheetIndex(6)->getStyle('A6:J6')->applyFromArray(
					array(
						'fill' => array(
							'type' => PHPExcel_Style_Fill::FILL_SOLID,
							'color' => array('rgb' => 'FFFF00')
						)
					)
				);
				
				
				$objPHPExcel->getActiveSheet(6)->getStyle('A4')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(6)->getStyle('A4')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(6)->getStyle('A4')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(6)->getStyle('A4')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
	
				$objPHPExcel->getActiveSheet(6)->getStyle('A6')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(6)->getStyle('A6')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(6)->getStyle('A6')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(6)->getStyle('A6')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(6)->getStyle('B6')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(6)->getStyle('B6')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(6)->getStyle('B6')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(6)->getStyle('B6')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(6)->getStyle('C6')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(6)->getStyle('C6')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(6)->getStyle('C6')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(6)->getStyle('C6')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(6)->getStyle('D6')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(6)->getStyle('D6')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(6)->getStyle('D6')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(6)->getStyle('D6')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(6)->getStyle('E6')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(6)->getStyle('E6')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(6)->getStyle('E6')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(6)->getStyle('E6')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(6)->getStyle('F6')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(6)->getStyle('F6')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(6)->getStyle('F6')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(6)->getStyle('F6')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(6)->getStyle('G6')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(6)->getStyle('G6')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(6)->getStyle('G6')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(6)->getStyle('G6')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(6)->getStyle('H6')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(6)->getStyle('H6')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(6)->getStyle('H6')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(6)->getStyle('H6')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(6)->getStyle('I6')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(6)->getStyle('I6')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(6)->getStyle('I6')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(6)->getStyle('I6')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(6)->getStyle('J6')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(6)->getStyle('J6')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(6)->getStyle('J6')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(6)->getStyle('J6')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);

				$objPHPExcel->getActiveSheet(6)->getStyle('A1')->getFont()->setSize(22);
				$objPHPExcel->getActiveSheet(6)->getStyle('A2')->getFont()->setSize(12);
				$objPHPExcel->getActiveSheet(6)->getStyle('B4')->getFont()->setSize(12);
				$objPHPExcel->getActiveSheet(6)->getStyle('A1')->getFont()->setBold(true);
				$objPHPExcel->getActiveSheet(6)->getStyle('A6:J6')->getFont()->setBold(true);
			
				$objPHPExcel->getActiveSheet(6)->setCellValue('A1', "LAPORAN PENANGANAN KOMPLAIN");
				$objPHPExcel->getActiveSheet(6)->setCellValue('A2', "Tanggal Pelaporan : ".date('d-m-Y',strtotime($get_taw))." - ".date('d-m-Y',strtotime($get_tak)));
				$objPHPExcel->getActiveSheet(6)->setCellValue('B4', "Bulan : ".$get_date." ".date('Y'));
	
				$objPHPExcel->getActiveSheet(6)->setCellValue('A6', "No");
				$objPHPExcel->getActiveSheet(6)->setCellValue('B6', "Tanggal");
				$objPHPExcel->getActiveSheet(6)->setCellValue('C6', "Nama Pemohon / Pelapor");
				$objPHPExcel->getActiveSheet(6)->setCellValue('D6', "No. Telepon");
				$objPHPExcel->getActiveSheet(6)->setCellValue('E6', "Email");
				$objPHPExcel->getActiveSheet(6)->setCellValue('F6', "No. UPTSA");
				$objPHPExcel->getActiveSheet(6)->setCellValue('G6', "Ijin yang diajukan");
				$objPHPExcel->getActiveSheet(6)->setCellValue('H6', "Isi Komplain");
				$objPHPExcel->getActiveSheet(6)->setCellValue('I6', "Keterangan");
				$objPHPExcel->getActiveSheet(6)->setCellValue('J6', "Verifikasi");
			
				$no 		= 1;
				$numb 		= 7;
				$status		= "";
				foreach($get_dapen_siup as $row)
				{
					$get_proses 	= $this->m_proses_pengaduan_saran->get_proses($row["KD_LIST_PENGADUAN"]);
					$get_verifikasi	= $this->m_proses_pengaduan_saran->get_verifikasi($row["KD_LIST_PENGADUAN"]);
					if($row["STATUS"] == 1)
					{
						$status = "SELESAI";
					}
					elseif($row["STATUS"] == 2)
					{
						$status = "PROSES";
					}
				
					$objPHPExcel->getActiveSheet(6)->getStyle('A'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(6)->getStyle('A'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(6)->getStyle('A'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(6)->getStyle('A'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(6)->getStyle('B'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(6)->getStyle('B'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(6)->getStyle('B'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(6)->getStyle('B'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(6)->getStyle('C'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(6)->getStyle('C'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(6)->getStyle('C'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(6)->getStyle('C'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(6)->getStyle('D'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(6)->getStyle('D'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(6)->getStyle('D'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(6)->getStyle('D'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(6)->getStyle('E'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(6)->getStyle('E'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(6)->getStyle('E'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(6)->getStyle('E'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(6)->getStyle('F'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(6)->getStyle('F'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(6)->getStyle('F'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(6)->getStyle('F'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(6)->getStyle('G'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(6)->getStyle('G'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(6)->getStyle('G'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(6)->getStyle('G'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(6)->getStyle('H'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(6)->getStyle('H'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(6)->getStyle('H'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(6)->getStyle('H'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(6)->getStyle('I'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(6)->getStyle('I'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(6)->getStyle('I'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(6)->getStyle('I'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(6)->getStyle('J'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(6)->getStyle('J'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(6)->getStyle('J'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(6)->getStyle('J'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
			
					$objPHPExcel->getActiveSheet(6)->setCellValue('A'.$numb, $no);
					$objPHPExcel->getActiveSheet(6)->setCellValue('B'.$numb, date('d-m-Y',strtotime($row["TANGGAL"])));
					$objPHPExcel->getActiveSheet(6)->setCellValue('C'.$numb, $row["NAMA"]);
					$objPHPExcel->getActiveSheet(6)->setCellValue('D'.$numb, $row["NO_TELEPON"]);
					$objPHPExcel->getActiveSheet(6)->setCellValue('E'.$numb, $row["EMAIL"]);
					$objPHPExcel->getActiveSheet(6)->setCellValue('F'.$numb, $row["NO_UPTSA"]);
					$objPHPExcel->getActiveSheet(6)->setCellValue('G'.$numb, $row["NAMA_IJIN"]);
					$objPHPExcel->getActiveSheet(6)->setCellValue('H'.$numb, $row["ISI"]);
					$objPHPExcel->getActiveSheet(6)->getStyle('H'.$numb)->getAlignment()->setWrapText(true);
					$string = "";
					$i = 0;
					foreach($get_proses as $row){
						$get_dates = "";
						if(date('m',strtotime($row["TANGGAL"])) == 1){
							$get_dates = "Januari";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 2){
							$get_date = "Februari";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 3){
							$get_dates = "Maret";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 4){
							$get_dates = "April";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 5){
							$get_dates = "Mei";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 6){
							$get_dates = "Juni";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 7){
							$get_dates = "Juli";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 8){
							$get_dates = "Agustus";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 9){
							$get_dates = "September";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 10){
							$get_dates = "Oktober";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 11){
							$get_dates = "November";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 12){
							$get_dates = "Desember";
						}
						$string .= " > ".date('d',strtotime($row["TANGGAL"]))." ".$get_dates." ".date('Y',strtotime($row["TANGGAL"])).", ".$row["KETERANGAN"]."\n";
						$i++;
					};
					$objPHPExcel->getActiveSheet(6)->setCellValue('I'.$numb, $string);
					$objPHPExcel->getActiveSheet(6)->getStyle('I'.$numb)->getAlignment()->setWrapText(true);
					$objPHPExcel->getActiveSheet(6)->getStyle('I'.$numb)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
					$string2 = "";
					$j = 0;
					foreach($get_verifikasi as $row){
						$get_dates = "";
						if(date('m',strtotime($row["TANGGAL"])) == 1){
							$get_dates = "Januari";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 2){
							$get_date = "Februari";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 3){
							$get_dates = "Maret";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 4){
							$get_dates = "April";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 5){
							$get_dates = "Mei";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 6){
							$get_dates = "Juni";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 7){
							$get_dates = "Juli";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 8){
							$get_dates = "Agustus";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 9){
							$get_dates = "September";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 10){
							$get_dates = "Oktober";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 11){
							$get_dates = "November";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 12){
							$get_dates = "Desember";
						}
						$string2 .= $row["KETERANGAN"]."\n"."Tgl, ".date('d',strtotime($row["TANGGAL"]))." ".$get_dates." ".date('Y',strtotime($row["TANGGAL"]));
						$i++;
					};
					$objPHPExcel->getActiveSheet(6)->setCellValue('J'.$numb, $status."\n".$string2);
					$objPHPExcel->getActiveSheet(6)->getStyle('J'.$numb)->getAlignment()->setWrapText(true);
					$numb++;
					$no++;
				}
				
				//ijin IPT
				$objPHPExcel->createSheet(7);
				$objPHPExcel->getSheet(7)->setTitle('IPT');
				
				$objPHPExcel->setActiveSheetIndex(7);
				
				$objPHPExcel->setActiveSheetIndex(7)->mergeCells('A1:J1');
				$objPHPExcel->setActiveSheetIndex(7)->mergeCells('A2:J2');
				$objPHPExcel->setActiveSheetIndex(7)->mergeCells('B4:C4');
			
				$objPHPExcel->getActiveSheet(7)->getColumnDimension('A')->setAutoSize(true);
				$objPHPExcel->getActiveSheet(7)->getColumnDimension('B')->setAutoSize(true);
				$objPHPExcel->getActiveSheet(7)->getColumnDimension('C')->setAutoSize(true);
				$objPHPExcel->getActiveSheet(7)->getColumnDimension('D')->setAutoSize(true);
				$objPHPExcel->getActiveSheet(7)->getColumnDimension('E')->setAutoSize(true);
				$objPHPExcel->getActiveSheet(7)->getColumnDimension('F')->setAutoSize(true);
				$objPHPExcel->getActiveSheet(7)->getColumnDimension('G')->setAutoSize(true);
				$objPHPExcel->getActiveSheet(7)->getColumnDimension('H')->setAutoSize(false);
				$objPHPExcel->getActiveSheet(7)->getColumnDimension('H')->setWidth(50);
				$objPHPExcel->getActiveSheet(7)->getColumnDimension('I')->setAutoSize(true);
				$objPHPExcel->getActiveSheet(7)->getColumnDimension('J')->setAutoSize(true);
				
				$objPHPExcel->getDefaultStyle()->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
				
				$objPHPExcel->setActiveSheetIndex(7)->getStyle('A6:J6')->applyFromArray(
					array(
						'fill' => array(
							'type' => PHPExcel_Style_Fill::FILL_SOLID,
							'color' => array('rgb' => 'FFFF00')
						)
					)
				);
				
				
				$objPHPExcel->getActiveSheet(7)->getStyle('A4')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(7)->getStyle('A4')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(7)->getStyle('A4')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(7)->getStyle('A4')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
	
				$objPHPExcel->getActiveSheet(7)->getStyle('A6')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(7)->getStyle('A6')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(7)->getStyle('A6')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(7)->getStyle('A6')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(7)->getStyle('B6')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(7)->getStyle('B6')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(7)->getStyle('B6')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(7)->getStyle('B6')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(7)->getStyle('C6')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(7)->getStyle('C6')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(7)->getStyle('C6')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(7)->getStyle('C6')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(7)->getStyle('D6')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(7)->getStyle('D6')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(7)->getStyle('D6')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(7)->getStyle('D6')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(7)->getStyle('E6')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(7)->getStyle('E6')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(7)->getStyle('E6')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(7)->getStyle('E6')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(7)->getStyle('F6')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(7)->getStyle('F6')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(7)->getStyle('F6')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(7)->getStyle('F6')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(7)->getStyle('G6')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(7)->getStyle('G6')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(7)->getStyle('G6')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(7)->getStyle('G6')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(7)->getStyle('H6')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(7)->getStyle('H6')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(7)->getStyle('H6')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(7)->getStyle('H6')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(7)->getStyle('I6')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(7)->getStyle('I6')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(7)->getStyle('I6')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(7)->getStyle('I6')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(7)->getStyle('J6')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(7)->getStyle('J6')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(7)->getStyle('J6')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(7)->getStyle('J6')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);

				$objPHPExcel->getActiveSheet(7)->getStyle('A1')->getFont()->setSize(22);
				$objPHPExcel->getActiveSheet(7)->getStyle('A2')->getFont()->setSize(12);
				$objPHPExcel->getActiveSheet(7)->getStyle('B4')->getFont()->setSize(12);
				$objPHPExcel->getActiveSheet(7)->getStyle('A1')->getFont()->setBold(true);
				$objPHPExcel->getActiveSheet(7)->getStyle('A6:J6')->getFont()->setBold(true);
			
				$objPHPExcel->getActiveSheet(7)->setCellValue('A1', "LAPORAN PENANGANAN KOMPLAIN");
				$objPHPExcel->getActiveSheet(7)->setCellValue('A2', "Tanggal Pelaporan : ".date('d-m-Y',strtotime($get_taw))." - ".date('d-m-Y',strtotime($get_tak)));
				$objPHPExcel->getActiveSheet(7)->setCellValue('B4', "Bulan : ".$get_date." ".date('Y'));
	
				$objPHPExcel->getActiveSheet(7)->setCellValue('A6', "No");
				$objPHPExcel->getActiveSheet(7)->setCellValue('B6', "Tanggal");
				$objPHPExcel->getActiveSheet(7)->setCellValue('C6', "Nama Pemohon / Pelapor");
				$objPHPExcel->getActiveSheet(7)->setCellValue('D6', "No. Telepon");
				$objPHPExcel->getActiveSheet(7)->setCellValue('E6', "Email");
				$objPHPExcel->getActiveSheet(7)->setCellValue('F6', "No. UPTSA");
				$objPHPExcel->getActiveSheet(7)->setCellValue('G6', "Ijin yang diajukan");
				$objPHPExcel->getActiveSheet(7)->setCellValue('H6', "Isi Komplain");
				$objPHPExcel->getActiveSheet(7)->setCellValue('I6', "Keterangan");
				$objPHPExcel->getActiveSheet(7)->setCellValue('J6', "Verifikasi");
			
				$no 		= 1;
				$numb 		= 7;
				$status		= "";
				foreach($get_dapen_ipt as $row)
				{
					$get_proses 	= $this->m_proses_pengaduan_saran->get_proses($row["KD_LIST_PENGADUAN"]);
					$get_verifikasi	= $this->m_proses_pengaduan_saran->get_verifikasi($row["KD_LIST_PENGADUAN"]);
					if($row["STATUS"] == 1)
					{
						$status = "SELESAI";
					}
					elseif($row["STATUS"] == 2)
					{
						$status = "PROSES";
					}
				
					$objPHPExcel->getActiveSheet(7)->getStyle('A'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(7)->getStyle('A'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(7)->getStyle('A'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(7)->getStyle('A'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(7)->getStyle('B'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(7)->getStyle('B'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(7)->getStyle('B'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(7)->getStyle('B'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(7)->getStyle('C'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(7)->getStyle('C'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(7)->getStyle('C'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(7)->getStyle('C'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(7)->getStyle('D'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(7)->getStyle('D'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(7)->getStyle('D'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(7)->getStyle('D'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(7)->getStyle('E'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(7)->getStyle('E'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(7)->getStyle('E'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(7)->getStyle('E'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(7)->getStyle('F'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(7)->getStyle('F'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(7)->getStyle('F'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(7)->getStyle('F'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(7)->getStyle('G'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(7)->getStyle('G'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(7)->getStyle('G'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(7)->getStyle('G'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(7)->getStyle('H'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(7)->getStyle('H'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(7)->getStyle('H'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(7)->getStyle('H'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(7)->getStyle('I'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(7)->getStyle('I'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(7)->getStyle('I'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(7)->getStyle('I'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(7)->getStyle('J'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(7)->getStyle('J'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(7)->getStyle('J'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(7)->getStyle('J'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
			
					$objPHPExcel->getActiveSheet(7)->setCellValue('A'.$numb, $no);
					$objPHPExcel->getActiveSheet(7)->setCellValue('B'.$numb, date('d-m-Y',strtotime($row["TANGGAL"])));
					$objPHPExcel->getActiveSheet(7)->setCellValue('C'.$numb, $row["NAMA"]);
					$objPHPExcel->getActiveSheet(7)->setCellValue('D'.$numb, $row["NO_TELEPON"]);
					$objPHPExcel->getActiveSheet(7)->setCellValue('E'.$numb, $row["EMAIL"]);
					$objPHPExcel->getActiveSheet(7)->setCellValue('F'.$numb, $row["NO_UPTSA"]);
					$objPHPExcel->getActiveSheet(7)->setCellValue('G'.$numb, $row["NAMA_IJIN"]);
					$objPHPExcel->getActiveSheet(7)->setCellValue('H'.$numb, $row["ISI"]);
					$objPHPExcel->getActiveSheet(7)->getStyle('H'.$numb)->getAlignment()->setWrapText(true);
					$string = "";
					$i = 0;
					foreach($get_proses as $row){
						$get_dates = "";
						if(date('m',strtotime($row["TANGGAL"])) == 1){
							$get_dates = "Januari";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 2){
							$get_date = "Februari";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 3){
							$get_dates = "Maret";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 4){
							$get_dates = "April";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 5){
							$get_dates = "Mei";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 6){
							$get_dates = "Juni";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 7){
							$get_dates = "Juli";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 8){
							$get_dates = "Agustus";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 9){
							$get_dates = "September";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 10){
							$get_dates = "Oktober";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 11){
							$get_dates = "November";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 12){
							$get_dates = "Desember";
						}
						$string .= " > ".date('d',strtotime($row["TANGGAL"]))." ".$get_dates." ".date('Y',strtotime($row["TANGGAL"])).", ".$row["KETERANGAN"]."\n";
						$i++;
					};
					$objPHPExcel->getActiveSheet(7)->setCellValue('I'.$numb, $string);
					$objPHPExcel->getActiveSheet(7)->getStyle('I'.$numb)->getAlignment()->setWrapText(true);
					$objPHPExcel->getActiveSheet(7)->getStyle('I'.$numb)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
					$string2 = "";
					$j = 0;
					foreach($get_verifikasi as $row){
						$get_dates = "";
						if(date('m',strtotime($row["TANGGAL"])) == 1){
							$get_dates = "Januari";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 2){
							$get_date = "Februari";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 3){
							$get_dates = "Maret";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 4){
							$get_dates = "April";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 5){
							$get_dates = "Mei";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 6){
							$get_dates = "Juni";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 7){
							$get_dates = "Juli";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 8){
							$get_dates = "Agustus";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 9){
							$get_dates = "September";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 10){
							$get_dates = "Oktober";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 11){
							$get_dates = "November";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 12){
							$get_dates = "Desember";
						}
						$string2 .= $row["KETERANGAN"]."\n"."Tgl, ".date('d',strtotime($row["TANGGAL"]))." ".$get_dates." ".date('Y',strtotime($row["TANGGAL"]));
						$i++;
					};
					$objPHPExcel->getActiveSheet(7)->setCellValue('J'.$numb, $status."\n".$string2);
					$objPHPExcel->getActiveSheet(7)->getStyle('J'.$numb)->getAlignment()->setWrapText(true);
					$numb++;
					$no++;
				}
				
				//ijin Lainnya
				$objPHPExcel->createSheet(8);
				$objPHPExcel->getSheet(8)->setTitle('Lain - lain');
				
				$objPHPExcel->setActiveSheetIndex(8);
				
				$objPHPExcel->setActiveSheetIndex(8)->mergeCells('A1:J1');
				$objPHPExcel->setActiveSheetIndex(8)->mergeCells('A2:J2');
				$objPHPExcel->setActiveSheetIndex(8)->mergeCells('B4:C4');
			
				$objPHPExcel->getActiveSheet(8)->getColumnDimension('A')->setAutoSize(true);
				$objPHPExcel->getActiveSheet(8)->getColumnDimension('B')->setAutoSize(true);
				$objPHPExcel->getActiveSheet(8)->getColumnDimension('C')->setAutoSize(true);
				$objPHPExcel->getActiveSheet(8)->getColumnDimension('D')->setAutoSize(true);
				$objPHPExcel->getActiveSheet(8)->getColumnDimension('E')->setAutoSize(true);
				$objPHPExcel->getActiveSheet(8)->getColumnDimension('F')->setAutoSize(true);
				$objPHPExcel->getActiveSheet(8)->getColumnDimension('G')->setAutoSize(true);
				$objPHPExcel->getActiveSheet(8)->getColumnDimension('H')->setAutoSize(false);
				$objPHPExcel->getActiveSheet(8)->getColumnDimension('H')->setWidth(50);
				$objPHPExcel->getActiveSheet(8)->getColumnDimension('I')->setAutoSize(true);
				$objPHPExcel->getActiveSheet(8)->getColumnDimension('J')->setAutoSize(true);
				
				$objPHPExcel->getDefaultStyle()->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
				
				$objPHPExcel->setActiveSheetIndex(8)->getStyle('A6:J6')->applyFromArray(
					array(
						'fill' => array(
							'type' => PHPExcel_Style_Fill::FILL_SOLID,
							'color' => array('rgb' => 'FFFF00')
						)
					)
				);
				
				
				$objPHPExcel->getActiveSheet(8)->getStyle('A4')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(8)->getStyle('A4')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(8)->getStyle('A4')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(8)->getStyle('A4')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
	
				$objPHPExcel->getActiveSheet(8)->getStyle('A6')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(8)->getStyle('A6')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(8)->getStyle('A6')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(8)->getStyle('A6')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(8)->getStyle('B6')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(8)->getStyle('B6')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(8)->getStyle('B6')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(8)->getStyle('B6')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(8)->getStyle('C6')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(8)->getStyle('C6')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(8)->getStyle('C6')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(8)->getStyle('C6')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(8)->getStyle('D6')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(8)->getStyle('D6')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(8)->getStyle('D6')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(8)->getStyle('D6')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(8)->getStyle('E6')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(8)->getStyle('E6')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(8)->getStyle('E6')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(8)->getStyle('E6')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(8)->getStyle('F6')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(8)->getStyle('F6')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(8)->getStyle('F6')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(8)->getStyle('F6')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(8)->getStyle('G6')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(8)->getStyle('G6')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(8)->getStyle('G6')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(8)->getStyle('G6')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(8)->getStyle('H6')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(8)->getStyle('H6')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(8)->getStyle('H6')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(8)->getStyle('H6')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(8)->getStyle('I6')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(8)->getStyle('I6')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(8)->getStyle('I6')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(8)->getStyle('I6')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(8)->getStyle('J6')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(8)->getStyle('J6')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(8)->getStyle('J6')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet(8)->getStyle('J6')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);

				$objPHPExcel->getActiveSheet(8)->getStyle('A1')->getFont()->setSize(22);
				$objPHPExcel->getActiveSheet(8)->getStyle('A2')->getFont()->setSize(12);
				$objPHPExcel->getActiveSheet(8)->getStyle('B4')->getFont()->setSize(12);
				$objPHPExcel->getActiveSheet(8)->getStyle('A1')->getFont()->setBold(true);
				$objPHPExcel->getActiveSheet(8)->getStyle('A6:J6')->getFont()->setBold(true);
		
				$objPHPExcel->getActiveSheet(8)->setCellValue('A1', "LAPORAN PENANGANAN KOMPLAIN");
				$objPHPExcel->getActiveSheet(8)->setCellValue('A2', "Tanggal Pelaporan : ".date('d-m-Y',strtotime($get_taw))." - ".date('d-m-Y',strtotime($get_tak)));
				$objPHPExcel->getActiveSheet(8)->setCellValue('B4', "Bulan : ".$get_date." ".date('Y'));
	
				$objPHPExcel->getActiveSheet(8)->setCellValue('A6', "No");
				$objPHPExcel->getActiveSheet(8)->setCellValue('B6', "Tanggal");
				$objPHPExcel->getActiveSheet(8)->setCellValue('C6', "Nama Pemohon / Pelapor");
				$objPHPExcel->getActiveSheet(8)->setCellValue('D6', "No. Telepon");
				$objPHPExcel->getActiveSheet(8)->setCellValue('E6', "Email");
				$objPHPExcel->getActiveSheet(8)->setCellValue('F6', "No. UPTSA");
				$objPHPExcel->getActiveSheet(8)->setCellValue('G6', "Ijin yang diajukan");
				$objPHPExcel->getActiveSheet(8)->setCellValue('H6', "Isi Komplain");
				$objPHPExcel->getActiveSheet(8)->setCellValue('I6', "Keterangan");
				$objPHPExcel->getActiveSheet(8)->setCellValue('J6', "Verifikasi");
			
				$no 		= 1;
				$numb 		= 7;
				$status		= "";
				foreach($get_dapen_lain as $row)
				{
					$get_proses 	= $this->m_proses_pengaduan_saran->get_proses($row["KD_LIST_PENGADUAN"]);
					$get_verifikasi	= $this->m_proses_pengaduan_saran->get_verifikasi($row["KD_LIST_PENGADUAN"]);
					if($row["STATUS"] == 1)
					{
						$status = "SELESAI";
					}
					elseif($row["STATUS"] == 2)
					{
						$status = "PROSES";
					}
				
					$objPHPExcel->getActiveSheet(8)->getStyle('A'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(8)->getStyle('A'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(8)->getStyle('A'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(8)->getStyle('A'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(8)->getStyle('B'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(8)->getStyle('B'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(8)->getStyle('B'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(8)->getStyle('B'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(8)->getStyle('C'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(8)->getStyle('C'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(8)->getStyle('C'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(8)->getStyle('C'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(8)->getStyle('D'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(8)->getStyle('D'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(8)->getStyle('D'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(8)->getStyle('D'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(8)->getStyle('E'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(8)->getStyle('E'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(8)->getStyle('E'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(8)->getStyle('E'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(8)->getStyle('F'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(8)->getStyle('F'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(8)->getStyle('F'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(8)->getStyle('F'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(8)->getStyle('G'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(8)->getStyle('G'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(8)->getStyle('G'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(8)->getStyle('G'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(8)->getStyle('H'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(8)->getStyle('H'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(8)->getStyle('H'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(8)->getStyle('H'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(8)->getStyle('I'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(8)->getStyle('I'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(8)->getStyle('I'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(8)->getStyle('I'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(8)->getStyle('J'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(8)->getStyle('J'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(8)->getStyle('J'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet(8)->getStyle('J'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
			
					$objPHPExcel->getActiveSheet(8)->setCellValue('A'.$numb, $no);
					$objPHPExcel->getActiveSheet(8)->setCellValue('B'.$numb, date('d-m-Y',strtotime($row["TANGGAL"])));
					$objPHPExcel->getActiveSheet(8)->setCellValue('C'.$numb, $row["NAMA"]);
					$objPHPExcel->getActiveSheet(8)->setCellValue('D'.$numb, $row["NO_TELEPON"]);
					$objPHPExcel->getActiveSheet(8)->setCellValue('E'.$numb, $row["EMAIL"]);
					$objPHPExcel->getActiveSheet(8)->setCellValue('F'.$numb, $row["NO_UPTSA"]);
					$objPHPExcel->getActiveSheet(8)->setCellValue('G'.$numb, $row["NAMA_IJIN"]);
					$objPHPExcel->getActiveSheet(8)->setCellValue('H'.$numb, $row["ISI"]);
					$objPHPExcel->getActiveSheet(8)->getStyle('H'.$numb)->getAlignment()->setWrapText(true);
					$string = "";
					$i = 0;
					foreach($get_proses as $row){
						$get_dates = "";
						if(date('m',strtotime($row["TANGGAL"])) == 1){
							$get_dates = "Januari";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 2){
							$get_date = "Februari";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 3){
							$get_dates = "Maret";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 4){
							$get_dates = "April";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 5){
							$get_dates = "Mei";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 6){
							$get_dates = "Juni";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 7){
							$get_dates = "Juli";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 8){
							$get_dates = "Agustus";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 9){
							$get_dates = "September";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 10){
							$get_dates = "Oktober";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 11){
							$get_dates = "November";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 12){
							$get_dates = "Desember";
						}
						$string .= " > ".date('d',strtotime($row["TANGGAL"]))." ".$get_dates." ".date('Y',strtotime($row["TANGGAL"])).", ".$row["KETERANGAN"]."\n";
						$i++;
					};
					$objPHPExcel->getActiveSheet(8)->setCellValue('I'.$numb, $string);
					$objPHPExcel->getActiveSheet(8)->getStyle('I'.$numb)->getAlignment()->setWrapText(true);
					$objPHPExcel->getActiveSheet(8)->getStyle('I'.$numb)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
					$string2 = "";
					$j = 0;
					foreach($get_verifikasi as $row){
						$get_dates = "";
						if(date('m',strtotime($row["TANGGAL"])) == 1){
							$get_dates = "Januari";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 2){
							$get_date = "Februari";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 3){
							$get_dates = "Maret";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 4){
							$get_dates = "April";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 5){
							$get_dates = "Mei";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 6){
							$get_dates = "Juni";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 7){
							$get_dates = "Juli";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 8){
							$get_dates = "Agustus";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 9){
							$get_dates = "September";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 10){
							$get_dates = "Oktober";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 11){
							$get_dates = "November";
						}elseif(date('m',strtotime($row["TANGGAL"])) == 12){
							$get_dates = "Desember";
						}
						$string2 .= $row["KETERANGAN"]."\n"."Tgl, ".date('d',strtotime($row["TANGGAL"]))." ".$get_dates." ".date('Y',strtotime($row["TANGGAL"]));
						$i++;
					};
					$objPHPExcel->getActiveSheet(8)->setCellValue('J'.$numb, $status."\n".$string2);
					$objPHPExcel->getActiveSheet(8)->getStyle('J'.$numb)->getAlignment()->setWrapText(true);
					$numb++;
					$no++;
				}
				
				
				$objWriter = IOFactory::createWriter($objPHPExcel, 'Excel5');
				header('Content-Type: application/vnd.ms-excel');
				header('Content-Disposition: attachment;filename="Data Report Pengaduan.xls"');
				header('Cache-Control: max-age=0');
				$objWriter->save('php://output');
				
			}
			elseif($this->input->post("jenis_cetak") == 2)
			{
				//buat data sheet baru
				$objPHPExcel = new PHPExcel();
				$objPHPExcel->getProperties()->setTitle("title")->setDescription("description");
				
				$objPHPExcel->setActiveSheetIndex(0);
				
				//merge untuk judul
				$objPHPExcel->setActiveSheetIndex(0)->mergeCells('A1:I1');
				
				//mengatur lebar kolom jadi auto
				$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setAutoSize(true);
				$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setAutoSize(true);
				$objPHPExcel->getActiveSheet()->getColumnDimension('C')->setAutoSize(true);
				$objPHPExcel->getActiveSheet()->getColumnDimension('D')->setAutoSize(true);
				$objPHPExcel->getActiveSheet()->getColumnDimension('E')->setAutoSize(true);
				$objPHPExcel->getActiveSheet()->getColumnDimension('F')->setAutoSize(true);
				$objPHPExcel->getActiveSheet()->getColumnDimension('G')->setAutoSize(true);
				$objPHPExcel->getActiveSheet()->getColumnDimension('H')->setAutoSize(true);
				$objPHPExcel->getActiveSheet()->getColumnDimension('I')->setAutoSize(true);
				$objPHPExcel->getActiveSheet()->getColumnDimension('J')->setAutoSize(true);
				
				//mengatur teks align center
				$objPHPExcel->getDefaultStyle()->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
				
				$objPHPExcel->setActiveSheetIndex(0)->getStyle('A4:J4')->applyFromArray(
					array(
						'fill' => array(
							'type' => PHPExcel_Style_Fill::FILL_SOLID,
							'color' => array('rgb' => 'FFFF00')
						)
					)
				);
				
				//mengatur border header tabel
				//$objPHPExcel->getActiveSheet()->getStyle('A4:E4')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
				$objPHPExcel->getActiveSheet()->getStyle('A4')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet()->getStyle('A4')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet()->getStyle('A4')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet()->getStyle('A4')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet()->getStyle('B4')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet()->getStyle('B4')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet()->getStyle('B4')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet()->getStyle('B4')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet()->getStyle('C4')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet()->getStyle('C4')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet()->getStyle('C4')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet()->getStyle('C4')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet()->getStyle('D4')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet()->getStyle('D4')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet()->getStyle('D4')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet()->getStyle('D4')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet()->getStyle('E4')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet()->getStyle('E4')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet()->getStyle('E4')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet()->getStyle('E4')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet()->getStyle('F4')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet()->getStyle('F4')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet()->getStyle('F4')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet()->getStyle('F4')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet()->getStyle('G4')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet()->getStyle('G4')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet()->getStyle('G4')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet()->getStyle('G4')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet()->getStyle('H4')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet()->getStyle('H4')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet()->getStyle('H4')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet()->getStyle('H4')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet()->getStyle('I4')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet()->getStyle('I4')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet()->getStyle('I4')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet()->getStyle('I4')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet()->getStyle('J4')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet()->getStyle('J4')->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet()->getStyle('J4')->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				$objPHPExcel->getActiveSheet()->getStyle('J4')->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				
				//setting teks
				$objPHPExcel->getActiveSheet()->getStyle('A1')->getFont()->setSize(24);
				$objPHPExcel->getActiveSheet()->getStyle('A4:J4')->getFont()->setBold(true);
					
				//judul
				$objPHPExcel->getActiveSheet()->setCellValue('A1', "Laporan Kinerja Kepala Sub Unit Program dan Informasi");
				
				//set bulan
				$objPHPExcel->getActiveSheet()->setCellValue('A3', "Tanggal Awal : ".$get_taw);
				$objPHPExcel->getActiveSheet()->setCellValue('B3', "Tanggal Akhir : ".$get_tak);
				
				//tabel header
				$objPHPExcel->getActiveSheet()->setCellValue('A4', "No");
				$objPHPExcel->getActiveSheet()->setCellValue('B4', "Nama");
				$objPHPExcel->getActiveSheet()->setCellValue('C4', "No Telepon");
				$objPHPExcel->getActiveSheet()->setCellValue('D4', "Email");
				$objPHPExcel->getActiveSheet()->setCellValue('E4', "Isi");
				$objPHPExcel->getActiveSheet()->setCellValue('F4', "Media");
				$objPHPExcel->getActiveSheet()->setCellValue('G4', "Jenis Ijin");
				$objPHPExcel->getActiveSheet()->setCellValue('H4', "No UPTSA");
				$objPHPExcel->getActiveSheet()->setCellValue('I4', "Tanggal");
				$objPHPExcel->getActiveSheet()->setCellValue('J4', "Kategori");
				
				//isi kolom
				$no = 1;
				$numb = 5;
				foreach($get_data as $row){
					if($row["KD_IJIN"] == NULL){
						$nama_ijin = "-";
						$no_uptsa = "-";
					}else{
						$nama_ijin = $row["NAMA_IJIN"];
						$no_uptsa = $row["NO_UPTSA"];
					}
					if($row['MEDIA'] == 1){
						$media = "LANGSUNG";
					}elseif($row['MEDIA'] == 2){
						$media = "TELEPON";
					}elseif($row['MEDIA'] == 3){
						$media = "EMAIL";
					}elseif($row['MEDIA'] == 4){
						$media = "WEBSITE";
					}else{
						$media = "-";
					}
					if($row['KATEGORI_S'] == 1){
						$kategori = "Biaya";
					}elseif($row['KATEGORI_S'] == 2){
						$kategori = "SDM";
					}elseif($row['KATEGORI_S'] == 3){
						$kategori = "Waktu Penyelesaian";
					}elseif($row['KATEGORI_S'] == 4){
						$kategori = "Metode - Prosedur";
					}elseif($row['KATEGORI_S'] == 5){
						$kategori = "Dokumen Persyaratan";
					}elseif($row['KATEGORI_S'] == 6){
						$kategori = "Sarana Prasarana";
					}else{
						$kategori = "-";
					}
					$objPHPExcel->getActiveSheet()->getStyle('A'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('A'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('A'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('A'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('B'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('B'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('B'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('B'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('C'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('C'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('C'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('C'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('D'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('D'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('D'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('D'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('E'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('E'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('E'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('E'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('F'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('F'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('F'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('F'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('G'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('G'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('G'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('G'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('H'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('H'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('H'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('H'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('I'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('I'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('I'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('I'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('J'.$numb)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('J'.$numb)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('J'.$numb)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('J'.$numb)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					
					$objPHPExcel->getActiveSheet()->setCellValue('A'.$numb, $no);
					$objPHPExcel->getActiveSheet()->setCellValue('B'.$numb, $row["NAMA"]);
					$objPHPExcel->getActiveSheet()->setCellValue('C'.$numb, $row["NO_TELEPON"]);
					$objPHPExcel->getActiveSheet()->setCellValue('D'.$numb, $row["EMAIL"]);
					$objPHPExcel->getActiveSheet()->setCellValue('E'.$numb, $row["ISI"]);
					$objPHPExcel->getActiveSheet()->setCellValue('F'.$numb, $media);
					$objPHPExcel->getActiveSheet()->setCellValue('G'.$numb, $nama_ijin);
					$objPHPExcel->getActiveSheet()->setCellValue('H'.$numb, $no_uptsa);
					$objPHPExcel->getActiveSheet()->setCellValue('I'.$numb, date('d-m-Y',strtotime($row["TANGGAL"])));
					$objPHPExcel->getActiveSheet()->setCellValue('J'.$numb, $kategori);
					$numb++;
					$no++;
				}
				$numb2 = $numb;
				$no2 = $no;
				foreach($get_ikm as $row)
				{
					$objPHPExcel->getActiveSheet()->getStyle('A'.$numb2)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('A'.$numb2)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('A'.$numb2)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('A'.$numb2)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('B'.$numb2)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('B'.$numb2)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('B'.$numb2)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('B'.$numb2)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('C'.$numb2)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('C'.$numb2)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('C'.$numb2)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('C'.$numb2)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('D'.$numb2)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('D'.$numb2)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('D'.$numb2)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('D'.$numb2)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('E'.$numb2)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('E'.$numb2)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('E'.$numb2)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('E'.$numb2)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('F'.$numb2)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('F'.$numb2)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('F'.$numb2)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('F'.$numb2)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('G'.$numb2)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('G'.$numb2)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('G'.$numb2)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('G'.$numb2)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('H'.$numb2)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('H'.$numb2)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('H'.$numb2)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('H'.$numb2)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('I'.$numb2)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('I'.$numb2)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('I'.$numb2)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('I'.$numb2)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('J'.$numb2)->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('J'.$numb2)->getBorders()->getBottom()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('J'.$numb2)->getBorders()->getLeft()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
					$objPHPExcel->getActiveSheet()->getStyle('J'.$numb2)->getBorders()->getRight()->setBorderStyle(PHPExcel_Style_Border::BORDER_THIN);
				
					$objPHPExcel->getActiveSheet()->setCellValue('A'.$numb2, $no2);
					$objPHPExcel->getActiveSheet()->setCellValue('B'.$numb2, "(IKM)");
					$objPHPExcel->getActiveSheet()->setCellValue('C'.$numb2, "(IKM)");
					$objPHPExcel->getActiveSheet()->setCellValue('D'.$numb2, "(IKM)");
					$objPHPExcel->getActiveSheet()->setCellValue('E'.$numb2, $row["kritik_saran"]);
					$objPHPExcel->getActiveSheet()->setCellValue('F'.$numb2, "(IKM)");
					$objPHPExcel->getActiveSheet()->setCellValue('G'.$numb2, "(IKM)");
					$objPHPExcel->getActiveSheet()->setCellValue('H'.$numb2, "(IKM)");
					$objPHPExcel->getActiveSheet()->setCellValue('I'.$numb2, date('d-m-Y',strtotime($row["TGL_KUESIONER"])));
					$objPHPExcel->getActiveSheet()->setCellValue('J'.$numb2, $row["kd_modul"]);
					
					$numb2++;
					$no2++;
				}
				
				
				$objWriter = IOFactory::createWriter($objPHPExcel, 'Excel5');
				header('Content-Type: application/vnd.ms-excel');
				header('Content-Disposition: attachment;filename="Data Saran Report.xls"');
				header('Cache-Control: max-age=0');
				$objWriter->save('php://output');
			}
			
		}
	}
	
	public function delete($id = NULL)
	{
		$this->m_list_pengaduan->delete($id);
		redirect('pengaduan_saran/grid_list_pengaduan');
	}
}